Pivot Table (how to apply conditional to dimension)

[Anonymous]

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.

[#2]

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

[Anonymous]

See attached PPT file. I think it´s clear.

Regards.

[#4]

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?