Is it possible to show duplicates?

[#1]

Hi,

I have duplicates in IDs when ID is moving from one progress item to another progress item

for eg:

Header 1	Header 2	Header 3
123	party	1
123	charity	2
123	IT	1
345	Welsher	1

will it be possible to show same ID three items in pivot/straight table?

Please can anyone let me know this.

[Gysbert_Wassenaar]

Yes, if you add the dimension(s) that makes the record unique. In your example the combination Header1-Header2 makes the records unique so you can use Header2 as dimension besides Header1.

[#3]

Thanks and I tried using dimesion. but still it is showing incorrect.  I should have give example like attached. please see attached.

Actually I have to show

No of IDs that moved from the party progressitem to the charity progressitem from 1st Aug 2012 to present?

Then for these particular IDs:
No of IDs that remain(ed) in charity progressitem
No of IDs that moved back to party progressitem