How to show selected and excluded in same table?

[#1]

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?

[#2]

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.