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:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.