Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
First all deselect the option of "Supress-Zero-Values" from presentation tab.
Then put your requisite condition in below said expression
=if(TRAFFIC_PLACE='FOA',Sum(TOTAL{<Traffic_in={'12'}>}#_NetSales),
Sum(#_NetSales)
)
also find the attached file
Your data model has synthetic key that's why its giving wrong results.
Except the ID_WAREH column rename all the keys which share common names in the other table that will resolve the issue
Thank you very much I fixed it but that doesn’t resolve my problem
i want to write something like
if TRAFFIC_PLACE=FOA then take all ID_WAREH and sum Net Sales
in one line. I don’t want to show results per ID_WAREH
you need in the front end ?
try like this
sum({<TRAFFIC_PLACE={FOA}>} [Net Sales])
if i write this in expession it will bring only the sales for FOA
can you explain with sample data ??
if possible provide sample app also??
Regards,
Yup
I have this table
TRAFFIC_PLACE | STORE | Traffic in | Tickets | Net Sales |
Bazaar Ag. Stefanos | Outlet Έδρας | 1 | 5 | 28 |
Collective Kolonaki | Collective Κολωνάκι | 3 | 5 | 35 |
Collective N. Erythrea | Collective Ν.Ερυθραίας | 2 | 4 | 26 |
Collective Psichiko | Collective Ψυχικού | 2 | 5 | 33 |
FOA | - | 41 | 0 | 0 |
GRE001 | Nike Γλυφάδας (Βουλιαγμένης) | 10 | 28 | 209 |
GRE002 | Nike Ψυχικού | 4 | 10 | 62 |
GRE005 | Nike Κηφισιάς | 3 | 7 | 52 |
GRE006 | Nike Πάτρας | 12 | 16 | 182 |
GRE007 | Nike Ν.Ερυθραίας | 3 | 7 | 44 |
For the traffic place FOA i want to write somehow in the expresion for Tickets and Net Sales that:
if traffic place =FOA then bring me the Net Sales for ID_WAREH =(5,13,27,46)
Try like this
if[TRAFFIC_PLACE] ='FOA',SUM({<ID_WAREH ={5,13,27,46}>}[Net Sales]) ,SUM([Net Sales]))
it doesnt work
sorry