I need to create a straight table from following data:
I have to create a list box for Client names so that user can select clients from that filter. This I have created.
Now in straight table I need to display following info:
|Total of 4 Products||<sum of all values of all 4 products of selected client>|
|Total of 3 Products||<sum of all values of all 3 products of selected client>|
|Total of 2 Products||<sum of all values of all 2 products of selected client>|
|Total of 1 Products||<sum of all values of all 1 products of selected client>|
Since in my data table I have more than 4 products but I need to do this operation on only given 4 products.
I am trying to do but I am getting straight table in wrong format.
Please help me in doing this.
Actually I have created cross table from my data table, where my fields in cross table are Client, Product, Value.
Now I was using if (match(Product, 'Prod-1'), 'Total of 1 Prod') type of expressions in dimension and SUM(Value) in expression.
But this is not working.
Actually I do not want to hardcode these things in Load script. So I am doing all these things in dashboard page only.
Is there any way as what I am doing in straight table is not giving correct output.