Measure by dimension

[danielrogra]

Hi all

I'm facing the following issue: I have a table with 3 kinds of information

Total	Type	Type2
1	A	A.1
2	A	A.2
1	B
3	B
1	C
6	C

and I'm trying to build the following pivot table:

	sum (Total) where type=A	sum (Total) where type=B	sum (Total) where type=C
A.1	1	4	7
A.2	2	4	7

Is there a way to do that?

Thanks in advance

Regards

[rubenmarin · Accepted solution]

Hi Daniel, as Type2 is not related to all records you can use TOTAL qualifier to avoid dimension values, and apply set analysis to filter by Type.

Using Type2 as dimension and 3 expressions/metrics:

- Sum({<Type={'A'}>} Total)

- Sum(TOTAL {<Type={'B'}>} Total)

- Sum(TOTAL {<Type={'C'}>} Total)

Naming a field 'Total' can make diffficult to different the qualifier TOTAL and the field Name.