Different Set Analysis in the same table

[robinwiman]

Hi,

I have these selections:

"EstoreOutlet" can be "1" or "0". Where 1 is concept, or all that is sold which is not on sales and 0 everything that is on sales.

"Store Type2" should always equal "E-store"

I want to create a table with many values, but for simplicity let's just say I need it for Sales.

I want the end result to be like:

                              Sales

E-store | Outlet     | ...

E-store | Concept  | ...

Problem is that I have a lot of different "Store Type2", which I don't want to show. And I need the table to hold and seperate "EstoreOutlet".

I desperately need help with a solution

[sunny_talwar]

Would you be able to some raw data with expected output to help understand what exactly you are looking to do?