Hi all,
I've been scouring around for a solution to my problem and although I've come across similar requests, I have yet to find a concrete answer.
My data is in a typical table format, basic columns of data. Some of these data columns are flags (numeric 1's, 0's, or blanks). My pivot table will count or sum these fields fine but when I drill down on a specific number the drill detail pulls all of the records for that category, including records that are set to a 0 or blank.
I've read something about slicers needing to be applied but I can't find that in my 2007 version. Is there any kind of work around for this?
Appreciate any help, thanks.
I've been scouring around for a solution to my problem and although I've come across similar requests, I have yet to find a concrete answer.
My data is in a typical table format, basic columns of data. Some of these data columns are flags (numeric 1's, 0's, or blanks). My pivot table will count or sum these fields fine but when I drill down on a specific number the drill detail pulls all of the records for that category, including records that are set to a 0 or blank.
I've read something about slicers needing to be applied but I can't find that in my 2007 version. Is there any kind of work around for this?
Appreciate any help, thanks.
