show only total in Pivot table

[vireshkolagimat]

Dear All,

I've a pivot table and it gives the sales by supplier and by store like the image attached.

I can show the total sales by both store and by supplier. How to show the count of stores where the sales value is zero. 

Regards,

Viresh

[NhanNguyen]

Have you tried to use set analysis? 

Maybe something like this: Aggr(Count(<{Value=0}>),Supplier)

[uacg0009]

Hi, Vireshkolagimat,
I think it's hard to add a expression next to your "total sales", but the table can be done by straight, there is a question, the number of your "store" is fixed or not? only 4 store?
if yes, I think you can hard-code it in straight table to make it.
Aiolos

[vireshkolagimat]

Hi, Kindly find the attached sample file. For each store i have two expressions ie sum(sales) and count(store). My requirement is instead of repeating the count metric for each store, is it possible to store the only grand total at the right side of the table. Thank you. Regards, Viresh

[vireshkolagimat]

Hi, The stores will vary but i need the expression as part of the pivot table. Thanks

[uacg0009]

Hi,
I found a way to make it in back-ground script, is that ok for you?
You can create a table like what you want in back-end.
Then use it in front-end.
Aiolos