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

[amit_saini]

Thanks Saumya but I have already tried all these suggestions .

Thanks,

AS

[saumyashah90]

What kind of ouput you want?

[amit_saini]

Should be based on level 1 0nly but need to show all other levels too.

[saumyashah90]

I meant to ask...

1)You need only one row with all levels?

2)Both rows but result displayed only on one row?

[amit_saini]

Only one row with all levels.

Thanks,
AS

[saumyashah90]

That should not be done anyways users want it so

For Level5 as Dimension -?Supress Null.. you will get your output

[jagan]

HI Amit,

Try like this

Dimension: Level1, Level1 Name

Expression: Maxstring(Level2), Maxstring(Level2 Name),..............................

When you use MaxString it will pull only value even you have 1 to many values.

If this is not you are expression then come up sample output that you are expecting with this 1 to many data.

Regards,

Jagan.

[amit_saini]

Sorry Jagan,

not working.

Please see the attachment  for desired result.

Thanks,

AS

[tyagishaila]

Hi Amit,

You can create a customized table,

A list box for dimensions,

Level 1

Level 2

Level 3

Level 4

and when you select here a dim Level 1,Pivot table show Level 1 data (as per your desired result)

like wise select Level 2, it shows Level 2 data and so on.

[amit_saini]

Thanks Shaila, I have already suggested this option to my client

But my user want to see this as I mentioned in my attachment.

Thanks,
AS