Pivot Table Condition

[jood_ahmad]

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

[Anil_Babu_Samineni]

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)