Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
i have a dashboard that i need little help on;
i have 7 stores in my dashboard and i want to display their sales separately but the sum is not summing up in the Straight table but when i filter the store it sum it up correctly.
i used this Expression if(Store_no = 1, sum(invoice_price))
i need help please. What can i do to get each straight table to sum my sales up correctly.
thank you.
Do all the seven stores have the same Store_no? If not then replace the if statement with sum(invoice_price) because the if statement will only sum the results for the stores with Store_no 1.
Would you share the Script. How you are loaded the 7 tables. And share screen shot which demonstrates the O/P
No, all store have different store no.
E.g for Store 1 = if(store_no = 1, sum(invoice_price)
store 2 = if(store_no = 2, sum(invoice_price) for all store till in different chart so i used 7 charts
but where i am to have total sales of each store i am not getting a sum up total sales....
Try expressions like this:
store 1: sum({<store_no={1}>}invoice_price)
store 2: sum({<store_no={2}>}invoice_price)
store 3: sum({<store_no={3}>}invoice_price)
store 4: sum({<store_no={4}>}invoice_price)
store 5: sum({<store_no={5}>}invoice_price)
store 6: sum({<store_no={6}>}invoice_price)
store 7: sum({<store_no={7}>}invoice_price)
total: sum({<store_no={1,2,3,4,5,6,7}>}invoice_price)
Thats the screenshot.
The if statement can't be evaluated at the total level so you don't get a total. Use the expressions I posted or set the Total mode of the expression to Sum of Rows.
the expression is working perfectly thank you.
sum({<STORE_NO={1}>}INVC_EXT_PRICE)
Thank You