Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
jj_kobalt
Contributor
Contributor

Calculated column pivot not showing on each row

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? 

 

Pivot.JPG

 Many thanks in advance

 
 
  •  
Labels (1)
0 Replies