Hmmm it's hard to tell from the image but the secondary data source should be aggregated at the level you are using in the view. Is it possible you have a dimension in 'Detail' (or setup on the blend relationship) that would make the secondary data source aggregate at a very granular level?
Hi, Thanks for your inputs. my secondary data source is at detail level. my view only shows the aggregated numbers.
secondary data source has 10 detail rows with different categories.
my view has to show how many rows per category.
i read you say "the secondary data source should be aggregated at the level you are using in the view"
mine does not follow that rule.
any suggestions? thankyou.
It's hard to tell. If you can attach a workbook with some sample data then we could likely troubleshoot better.