Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Period list and a Pivot Table that uses this dimension. When selecting more than one Period, I would like to see only the last selected one at the Pivot Table, but the total column should consider all selected Periods. I´ve made a conditional expression for Period dimension but it´s not fine.
[Período DRE]=right(getfieldselections ( [Período DRE] , ',',100),7)
See the attached file.
Could you elaborate more? Or post a picture of your table? It's not clear to me what you would like to achieve.
Br,
T
See attached PPT file. I think it´s clear.
Regards.
Paulo, I think the first thing you wanted is possible (''when selecting more than one Period, I would like to see only the last selected one at the Pivot Table''). The second one is the more interesting one. As far as I know, for that to be achieveable, you should be able to edit the subtotal expression in your pivot table, but I don't know a way to do that. Do anyone else know a method to do it?