Static Headers in Pivot Table

Ivak — Tue, 24 Sep 2024 15:23:36 GMT

Hello All,

I have input like below:

C#	Location	Mrkt	value
C1	Loc1	US	1
C1	Loc2	US	2
C2	Loc1	US	5
C2	Loc2	US	6
C2	Loc3	US	1

Trying to visualize above data (Location, Market, value) in Pivot table, C# in filter pane.
If user select 'C1' data from 'C#' from filter pane, I am expecting output like below:

Mrkt	Loc1	Loc2	Loc3
USA	1	2	0

Headers should be static.
In Pivot:
Dimension as 'Mrkt'
Column as 'Location'
Measure as Sum(value).

I tried multiple approach like loading separate inline table for Location values with this expression Sum({<Location={'Loc1','Loc2','Loc3'}>}value), but not works.

Thank you in advance for your solutions.

Re: Static Headers in Pivot Table

MatheusC — Tue, 24 Sep 2024 19:23:28 GMT

Hi @Ivak
This should return a value of zero to you, which in your example would be Loc3.

Sum(value) + sum({1} 0)

- Matheus

Re: Static Headers in Pivot Table

Ivak — Wed, 25 Sep 2024 09:19:19 GMT

Thankyou @MatheusC , Its working!!

topic Static Headers in Pivot Table in App Development

Static Headers in Pivot Table

Re: Static Headers in Pivot Table

Re: Static Headers in Pivot Table