Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 10 stores that sell 20 different products.
How can I create a straight table that, for every products, tell me how many stores didn't sell that product?
Hi Patrizio,
Dimension: Product
Expression: Count({<Sales = {'0'}>}Stores)
Your data is aggregated or each transaction level ?
You can Try like below:
Count({<Stores={"=Sum(SalesAmount)=0"}>}Stores)
Hi Patrizio, maybe:
Count(TOTAL DISTINCT Store) - Count(DISTINCT Store)
Dimension: Product
Expression: = Sum( Aggr( If(Sum(SalesAmount)=0,1,0), Product, Store))
The problem is with the incoming data. You can't display what doesn't exist.
Add a sale of 0.0001 to each product that the store didn't sell.
When you sum sales the missing store data for a product will be $0.00
A bar chart will also show what looks like zero sales for stores that didn't sell product.