Pivot Table Condition

jood_ahmad — Tue, 22 Jul 2025 17:59:49 GMT

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.

Re: Pivot Table Condition

Anil_Babu_Samineni — Wed, 03 May 2017 09:16:28 GMT

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)