Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Attached please find the sample qvw and excel file. I have a straight table with 2 dimensions. I am doing a simple sum of Sales.
My dimensions are Variety and Zone. All zones have 0 sales but "Null" Zone has a value of 30. I would like to show the value "30" in all Zones.
Can't seem to make it work. Any help is appreciated
Sum(TOTAL Sales)
Already tried that,it does not work because it will sum everything, I want the total at the variety level, so for example if I have variety No 2, it will have seperate total values for variety 1 and 2