Hi all,
I am looking for an aggregated cross tab report based on the data source below. Each column use different logic for aggregation. Please see the attached excel for the formulas involved.
Data source - sample | ||||
S.No | Dimension | Measure1 | Measure2 | Measure3 |
1 | A | Y | 0.5 | TRUE |
2 | B | N | 2.5 | FALSE |
3 | C | D | 3.5 | FALSE |
4 | A | Y | 1.5 | TRUE |
5 | B | Y | 1.4 | TRUE |
6 | C | Y | 1.3 | TRUE |
7 | A | N | 1.32 | FALSE |
8 | B | D | 2 | FALSE |
9 | C | Y | 3.5 | FALSE |
10 | A | Y | 4 | TRUE |
11 | B | N | 1.23 | TRUE |
12 | C | D | 2.43 | TRUE |
Expert Tableau worksheet | ||||
Category | % total - Msr1 | % total - Msr2 | % total - Msr3 | |
Y | 50.00% | 58.33% | 58.33% | |
N | 25.00% | 41.67% | 41.67% | |
D | 25.00% | 0.00% | 0.00% |