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.