Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Thanks in advance.
I have a sales report and I would like to have a straight table to show the selected team on left column and all the excluded columns on right by customer.
Customer: X, Y, Z
Team: A, B, C, D
when selected A,
A | B | C | D
X 1| 2 | 3 | 4
Y 2| 4 | 6 | 8
when selected B,
B | A | C | D
X 2 | 1 | 3 | 4
Y 4 | 2 | 6 | 8
I try put and If else case to dynamic to switch the 3 columns on right.
However, when I try to use the following to get the sum, I can't get the sum correctly.
Sum ({[Team]} if [Team] = 'B', Sales)
Anyone can help?
It sounds like you just need [Team] as the first dimension and [Customer] as the second dimension but I'm assuming I'm missing something.
I think the syntax on this statement is off: Sum ({[Team]} if [Team] = 'B', Sales)
As far as I know the {[Team]} part doesn't mean anything.
If you are trying to get the order of the columns to changed based on your selections... that I'm not sure how to do.