They are not seperate summaries. that's same summary (It's a single value. I choose any summary avg / sum)
If I choose 2 summaries they fall one below the other. I need count and % side by side. Hence I added another group called type with 2 types "#" and "%" for each category
CAT1...
Thank you for your detailed response. This mannual report is kind of a hardcoding (I have not tried it out but seems like it). I want something that would get automatically generated since none of the grouping fields are fixed. So I created a sql with many unions, so their is a state called z...
I am creating a cross tab report where I group on State(Row Header), City(Row sub header) and Category(column header). I calculate count of items sold in each category for each city. I also need to show percentage of items sold in each category and city over the total items sold in each city...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.