I'm trying to build a report in a pivot table with a condition in the expression based on the dimension column . and this is the details:
as you see the below table I have the type and A, B and this is the scenario; if the Type is Meat add 100 and if the Type is Veg add 50.
Type is Dim Column.
A is the, for example, the sales.(1st expression)
B is the result. (2nd expression).
it possible to but a condition in the expression based on the Dim in the same pivot table.
May be front end solution could be this?
Dimension as Type
2) If(Type = 'Meat',Sum(A) + 100, Sum(A)+50)
Or Use Dimension are Type and A
Then expression use same
If(Type = 'Meat',Sum(A) + 100, Sum(A)+50)