Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks ,
See below:
I'm using pivot table , from level1 to Level 5 name are my dimensions and Quantity and Price are expressions .
I'm simply calling Quantity and Price fields as expression .
Problem here is I'm getting duplicates numbers or values see below :
And If I'm calling only Level 1 and Level 1 Name as dimension and Quantity as expression I'm getting only single value .
My requirement here is to show all levels with there respective names as in image but Quantity and Price figures should not repeat.
Any Suggestion???
Thanks,
AS
as you show level 1 dim and expression, then
do you want same thing for level 2 ,
it must comes below level 1 or after price column of level 1?
I mean from where Level 2 info start ?
It should be in this order:
Thanks,
AS
I guess you will have to use text box and show them in one text box each.
This will increase your hardwork but might help you
aggr(only(Quantity), MaterialIDL1)
I think It can't be possible that ,
If we add level 2 level3... in desired result table then your desired result data will be definitely effected .
you have to clear it more.
No man all blank
just 1 more time show your desired table data, with level 1 and level 2 (not with level 1 only)
Please check my last attachment.
Thanks,
AS
Result should be :
1024936001- For this material number against all levels
Thanks,
AS
its not easy,
but if you show partial sum for level1 then this value is same in both the tables.
i