I'm a bit stuck with the creation of a formula.
I have a first dashboard with 1 column for a product dimension, 1 for the total sales (all clients included) and 1 with an measure (variable) saying "Yes" if the client distributes the product or "No" if not.
From this Table, I want to create a cross-table Client x Client with a single measure as follow:
For each combinaison Client 1 x Client 2 , Sum the Sales of the Client 1 where Client 1="Yes" and Client 2="No"
In excel I can do it with this formula
Is there a way to do it in Webi ? I can't find a solution.
Thank you for your help