Hey!
I have the following question / problem:
I got a list that looks like this:
What I am trying to do now is to compare ONE Store to all other stores in a 'specific' way.
Lets say I want to focus on StoreB.
So the result should look like this:
Mr. Moon with CustomerID 1 is buying in StoreA, StoreB and StoreC. If I focus on StoreB than StoreBs 'StorePartnerLevel' should be in an own column when / if the Customer also is buying in this store.
I tried achieving this with a Parameter and a Calculated field, but this didn´t work the way I wanted.
See the basic example attached(picture 1).
I hope you guys can help me with that problem!
Thanks a lot!
MG
Create a parameter with the store names. Next create 3 calculated fields:
1. To display the Level of the selected store: {FIXED [Customer ID]: MIN(IF [Store]= [StoreParameter] THEN [Store Partner Level] END)}
2. To hide the selected store from the store list in the table: [Store] = [StoreParameter]
3. To hide the 2nd customer ID when the selected store doesn't exist for the customer: IF ISNULL([Calculation1]) THEN '' ELSE STR([Customer ID]) END
Drag the first and third calculated fields into your table. Drag the second to filters and set to False.
Screenshot is here:
Workbook is attached.
