Pivot Table - How to show what is not been sold

[agigliotti]

Hello Experts,

Our customer ask us to create a pivot table with customers and product categories (dimensions) with the indication for each customer if that product category has been sold or not.

I just spent a lot of time to achieve it but with no luck.

Can anyone drive me to the right direction ?

Many thanks in advance.

Best Regards

Andrea

[agigliotti · Accepted solution]

The only way I found to solve the problem is using 2 distinct clouds inside the .qvw document: one cloud with all tables included the sales transactions table and the other cloud with only dimensions tables (duplicated with different names).

Now I get the expected results in pivot table but it takes a long time to calculate

In the expression I'm using IF statement instead of SET ANALYSIS because of separation of the two clouds.

Can someone help me to improve the object response time ?

Thanks & Regards

Andrea

[agigliotti]

I was able to improve the reponse time using set analysis for some field values to restrict the data the expression works on.

Best regards