Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.