I have created a tracker which allows mutliple selection of items for a given cell.
However when I run a pivot on that worksheet
What I require is for these items to be displayed independently.
However they appear clubbed together in the pivot.
Makes it difficult to create a dashboard and project an analysis for each of these independent items.
However when I run a pivot on that worksheet
What I require is for these items to be displayed independently.
However they appear clubbed together in the pivot.
Makes it difficult to create a dashboard and project an analysis for each of these independent items.