Showing all replica fields

[khaycock]

I have an Excel flat file that is showing 18 lines for new hires like this:

In my pivot table on the dashboard I want to display all 18 of these lines, but it is only showing the line once because it is the same. When a count is added you can see its 18 but I actually want it shown 18 times in the table instead?

Any ideas?                        

[sunny_talwar]

May be add a unique identifier while loading your data

LOAD RowNo() as UniqueIdentifier,

     Field1,

     Field2,

     Field3,

     ....

FROM ....;

and now add UniqueIdentifer as one of the pivot table dimension