Query// please try to give answer asap,its urgent

[Vijen_M]

INPUT SALESOUTPUT

i have one input table and i want output like single table,i want sum of sales but in sales column value of sales should be zero insted of sales value

[Mark_Little]

Hi,

I am not sure how to do this as you are trying to create at table with a Dimensionality and half ignore that. I would be questioning the use case. I would advise a KPI of Sales if you just want the total or show as the table on the left, As 0 + 0 + 0 + 0 isn't 10000.

[vinieme12 · Accepted solution]

This is an interview question 

hint:   dimensionality