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.
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.
What does ... I apply filter it retries only few records ... mean?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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.
Hi Srikanth,
Try using the Pivot table functionalities to get your desired result.