Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
How to remove the entire Row when all key figures are equal to 0
for reference please see the below table
product ,slaes ,cost, item
A,1,0,hello
b,0,1,hai
c,1,1,bang
d,0,0,hyd
In the above example 4 th row contains all key figures are 0 so i dont want entire row .
My question is how to delete the entire row?
O/p:
product ,slaes ,cost, item
A,1,0,hello
b,0,1,hai
c,1,1,bang
THanks in advance
Try this way?
Load product, slaes, cost, item From table where slaes>0 and cost>0