Skip to main content

Deployment Framework

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jood_ahmad
Creator II
Creator II

Pivot Table Condition

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 AB
Meat200
Veg321
Meat343
Meat765
Veg234
1 Reply
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)

Capture.PNG

Or Use Dimension are Type and A

Then expression use same

If(Type = 'Meat',Sum(A) + 100, Sum(A)+50)

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)