Table Cal help???

[amit_saini]

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

[tyagishaila]

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 ?

[amit_saini]

It should be in this order:

Thanks,
AS

[saumyashah90]

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

[renjithpl]

aggr(only(Quantity), MaterialIDL1)

[tyagishaila]

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.

[amit_saini]

No man all blank

[tyagishaila]

just 1 more time show your desired table data, with level 1 and level 2 (not with level 1 only)

[amit_saini]

Please check my last attachment.

Thanks,

AS

[amit_saini]

Result should be :

1024936001- For this material number against all levels

Thanks,

AS

[tyagishaila]

its not easy,

but if you show partial sum for level1 then this value is same in both the tables.

i