24. dubna 2012 14:03
I need to know if it is possible to change dinamically the label of a measure. Suppose to have the SumOfInvoices and a year slicer. If I choose year = 2012 I want to see a measure for the 2012 SumOfInvoices (and the related column label) and a measure for the 2011 SumOfInvoices; if I choose year = 2011, I want to see the 2011 SumOfInvoices and the 2010 SumOfInvoices.
Any suggests to me, please?
24. dubna 2012 14:18
One way to do this is switching from the pivot table to CUBE formulas. However, this is only a viable approach is you dont expect the data to expand/collapse dynamically. Would this work for you?
24. dubna 2012 14:32
I'd like to work with a PowerPivot table. My measures could be static but with the related column label with dynamic text, if possible.
24. dubna 2012 18:03
With pivot tables only, I dont believe what you need can be done (dynamic labels). You have two options, use CUBE formulas or use VBA. With CUBE formulas, you can generate dynamic formulas that would be used as column or row headers for your measures.
With VBA, you have an interface in which to build a custom pivot table.
- Označen jako odpověď Challen FuModerator 2. května 2012 8:39