Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the below table. I'm trying to create a pivot table (second table below) such that the locations "TR02,TR03,TR04" are pooled/aggregated in a single cell and renamed as "incomplete". Similarly location "SD" pooled and renamed as "finished". Then i can create a bar chart using this table as a filter so that it shows sum of completed qty for both "incomplete" and "finished" categories.
I used MATCH,AGGR,SET ANALYSIS and IF statements in calculated dimensions/Expressions tab for chart properties but they don't work. Please help me as it's driving me crazy.
product code | location | Qty |
Engine | SD | 1 |
Shaft | TR02 | 10 |
Pump | TR03 | 1 |
Shaft | TR04 | 0 |
Shaft | TR03 | 1 |
Pump | TR03 | 1 |
Engine | SD | 10 |
product code | location | Qty |
Engine | finished | 11 |
Transmission | incomplete | 11 |
Pump | incomplete | 2 |
This should work
Dimension
[product code] If(location = 'SD', 'finished', 'incomplete')
Expression
Sum(Qty)
This should work
Dimension
[product code] If(location = 'SD', 'finished', 'incomplete')
Expression
Sum(Qty)
Thank you Mr. sunny. I've another question for you:
what is the difference between "Add Calculated dimension" , "Edit" dimension and "Enable Conditional check box" options in dimensions?
In the answer you have given, i assume i have to use "Add calculated dimension" for IF statement?
Add Calculated dimension
Add a new dimension or calculated dimension
Edit dimension
Edit an existing dimension or calculated dimension
Enable Conditional check box
Display dimension or calculated dimension only when a certain condition is met.