Repetition of data in Pivot table

[#1]

Hi,

I am using a Pivot table which has multiple dimensions. I am using the total Row for each of the Dimensions.

The expression include some numbers which are added for and also a comments column.

Although I would like to see totals for the columns that display numbers but the repetition of remarks is undesirable.

is there a way to circumvent this problem.

Please let me know if you need more information.

Regards,

Rohit

[#2]

Hi,

This is because, the row value might differ at some point (may not be unique).

If your expression uses the Sum (), you can use the set Analysis and sum based on the unique value or for which the sum need to be displayed.

Sorry, i don't know how to explain with example.

[#3]

Thanks for your response Srinivasan.

MY problem is not the NUmbers. I am using the sum function for the numbers.

MY problem is the text(String). I want to show the comments only for one row and do not want itself to replicate for the rows above regardless of it is the unique value or not.

Please let me know if you need any further information.

Regards,

Rohit

[#4]

Hi Rohit,

Could you please post a sample data or Report ?

[#5]

Here in the attached image 'Text 7','Text3' and 'Text1' that appears in Bold is undesirable.

How can I avoid this repetition.

Regards,

Rohit

[#6]

Please let me know if it is still not clear.

Regard,

Rohit

[#7]

Hi Rohit,

I think you have chekced the Option "Partial Sum", hence it displays the multiple value at multiple line. If you collapse at the second column, you can find the difference.

You can also test this with Straight Table and remove "No total" option.

If this doesn't work, then post me the sample report.

[#8]

Hi,

I have checked the partial sum option because I need to sum up the 'count' column(in the screen shot).

Is there a way so that I can see the sub-totals in the 'count' column and dont see the repetion of the text.