Measure label changed dinamically

Question

Hi,

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?

Thanks

Answer 1

Hi pscorca,

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?

---

Javier Guillen
http://javierguillen.wordpress.com/

Answer 2

Hi Javier,

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.

Thanks

Answer 3

Hi pscorca

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.

---

Javier Guillen
http://javierguillen.wordpress.com/