Forum Discussion
Request Help. Removing Certain Data
This should do it. Since your table exists in the data model it gives you access to summarize the Claim by 'Distinct Count'.
Pivot Table.
Move all fields (Total amt excepted) to the Rows. Move total amount field to the values.
Change pivot table report layout to tabular. Turn off all subtotals. Grand totals may be removed, if desired.
Patrick2788 Thanks for the advice. I did as you suggested. The challenge I have when creating a pivot table with the current data set, is it gives me data I don't want reflected (the count is too high because of duplicate claim #'s).
For example, when I create a pivot and have "count as claim number" as a column it's including all the duplicate claims with the same name.
Any pivot I create has numbers I don't want. I need a way to remove duplicates (not the rows just the text in the field. The pictures I attached illustrate this.