Total Summing of Sales Dashboard

[oseimuduame]

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.

[Gysbert_Wassenaar]

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.

[Anil_Babu_Samineni]

Would you share the Script. How you are loaded the 7 tables. And share screen shot which demonstrates the O/P

[oseimuduame]

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....

[Gysbert_Wassenaar]

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)

[oseimuduame]

Thats the screenshot.

[Gysbert_Wassenaar]

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.

[oseimuduame]

the expression is working perfectly thank you.

sum({<STORE_NO={1}>}INVC_EXT_PRICE)

Thank You