I have a pivot table with expanding columns and one calculated dimension (PY Price). The user needs to visualize the calculated
dimension for all levels even if he collapses one of the level. My problem is, when I collapse one column, the calculated
dimension - which is the last column in the table - disappears because it behaves as a dimension in a pivot table.
(see the enclosed file).
What should I do in order to always visualize the calculated dimension? Consider that I can't transform it into an
expression because on horizontal I have the detail for Month and it would split it into months