Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ProdHier1 | Division | Source | Cube | Value |
---|---|---|---|---|
LVP | 10 | SOURCE1 | ZSD22 | 150 |
LVP | 20 | SOURCE1 | ZSD22 | 50 |
SYS | 10 | SOURCE2 | ZSD44 | 200 |
LVP | 99 | SOURCE2 | ZSD44 | 50 |
SYS | 20 | SOURCE1 | ZSD22 | 100 |
LVP | 10 | SOURCE2 | ZSD22 | 50 |
Product | Value |
---|---|
ProductGrouping1 | 200 |
I cant quite picture the right way to do it? Map the data in the script as i load it from the QVD? Or some other variable expression magic which i cant work out!?
Much thanks in advance.
if your grouping is static, do this in the script, maybe like
LOAD
PRODHIER1,
DIVISION,
SOURCE,
CUBE,
VALUE,
if(PRODHIER = 'LVP' and DIVISION = 10 and CUBE ='ZSD22', 'ProductGrouping1','SomethingElse')
as PRODUCT,
....
Regards,
Stefan
Hi ,
You can achieve this through backend
temp1:
Load distinct ProdHeir,Division,Cube,ProductGrouping&' '&rowno() as ProductGroup
resident (above table mentioned by you )
temp2:
Load ProdHeir&Division&Cube as PDC,ProductGrouping
resident temp1;
drop table temp1;
temp3:
Load *,ProdHeir&Division&Cube as PDC
resident ((above table mentioned by you ));
drop table ((above table mentioned by you ));
left join (temp3)
load * resident temp2
Infront end
then you can create a chart with dimensioin ProductGrouping and expression sum (Value)