Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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