Mrs_PowerPivotExcel
New Member
- Joined
- Nov 30, 2013
- Messages
- 4
Dear Experts
I am having a problem with creating a slicer for sum of measures. Basically, I've created sum of measures of 30 companies, using the cost allocation into each company by fixed %. I'd like to have a slicer of company to be able to slice out the figures into each company. But as each company figures are created by allocation of costs into companies rather than underlying database data, I find it hard to create slicer of measures. Please me know how I can slice out measures. Sorry if my explanation of the issue above is not clear.
I am having a problem with creating a slicer for sum of measures. Basically, I've created sum of measures of 30 companies, using the cost allocation into each company by fixed %. I'd like to have a slicer of company to be able to slice out the figures into each company. But as each company figures are created by allocation of costs into companies rather than underlying database data, I find it hard to create slicer of measures. Please me know how I can slice out measures. Sorry if my explanation of the issue above is not clear.