Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want add 2 values into single value in dimension.
1) Here 5 values(EAST,North,South,Unknown,West) are there but i want add 'Unknown' and 'EAST' into single value like 'EAST' then sum of sales also automatically show single value right.how to combine
2) How to display Highest value in sum(sales) and corresponding Region also.
i am using Aggr() it show only highest value but not Region
i attache QVW file also
please give reply...
Thanks
Best is to do it in the script:
Directory;
LOAD if(Region='Unknown','EAST', Region) as Region ,
sales
FROM
(ooxml, embedded labels, table is Sheet1);
I think there is no data in your attached app. Can you reload and repost your app?
Best is to do it in the script:
Directory;
LOAD if(Region='Unknown','EAST', Region) as Region ,
sales
FROM
(ooxml, embedded labels, table is Sheet1);
Ok Bro
Thanks...working fine