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
Thanks Saumya but I have already tried all these suggestions .
Thanks,
AS
What kind of ouput you want?
Should be based on level 1 0nly but need to show all other levels too.
I meant to ask...
1)You need only one row with all levels?
2)Both rows but result displayed only on one row?
Only one row with all levels.
Thanks,
AS
That should not be done anyways users want it so
For Level5 as Dimension -?Supress Null.. you will get your output
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.
Sorry Jagan,
not working.
Please see the attachment for desired result.
Thanks,
AS
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.
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