Dear forum,
I got a problem in my pivot, where i got a calculated column.
I am using the following expression: 'If(Match([Store ID],4), Sum(TOTAL {<[Store ID] = {1,2}>}$(vYTD)))', where store ID is a column and vYTD my measure.
My problem is that the calculated field only calculates the value to the no dimension field, how can I change my expression so it shows on each row for every dimension the calculated field?
Many thanks in advance