Hi everyone,
I have a Vizlib Pivot Table where I am trying to show 5 different account numbers in one table.
I want to change the title/label of the measures based on the account number.
| Account Number | Measures | Assets |
| 001 | Label 1 | $100 |
| 100 | Label 2 | $450 |
| 101 | Label 3 | $ ... |
| 110 | Label 4 | $ ... |
I am using Set Expressions and IF loop to get the corresponding calculations for each account number.
However, when I tried to use IF loop to get the appropriate label, it won't work.
I am wondering whether it is even possible.
Thank you!
