Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears,
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.
Type | A | B |
Meat | 200 | |
Veg | 321 | |
Meat | 343 | |
Meat | 765 | |
Veg | 234 |
May be front end solution could be this?
Dimension as Type
Expressions are
1) Sum(A)
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)