even if I use a report filter..I noticed that when I try to filter further via the pivot items ...I still see all the data even though I filtered vis the report filter ....is there way to make the pivot filter out the data accordingly ?
eg I use report to filter for today's date
but when I try to filter for a specific IDin the pivot item ..I still see IDs from other dates in the drop down list ...is there a way to eliminate that?
eg I use report to filter for today's date
but when I try to filter for a specific IDin the pivot item ..I still see IDs from other dates in the drop down list ...is there a way to eliminate that?