PDA

View Full Version : Group and filter the data



srikanthsho
09-25-2009, 06:10 AM
Hi I am very new to XL BI Reporting. I want the data to be grouped and filtered as shown below. After grouping the data(as shown below)if I apply filter it retries only few records How to solve this ? Any Suggestions are appreciated.

Bob Phillips
09-25-2009, 09:07 AM
What does ... I apply filter it retries only few records ... mean?

srikanthsho
09-25-2009, 09:59 PM
Hi Nihil
After grouping the data, the data available in the grouped column will be one unique data value. If I apply the filter then it retrieves the data for only one unique data value row where as it should retrieve compleate data for the grouped item.

sai_golden
09-26-2009, 04:47 AM
Hi Srikanth,

Try using the Pivot table functionalities to get your desired result.

:friends: