Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by vshah007

  1. vshah007

    Crosstab summary problem How to create percentofCount in crosstab

    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...
  2. vshah007

    Crosstab summary problem How to create percentofCount in crosstab

    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...
  3. vshah007

    Crosstab summary problem How to create percentofCount in crosstab

    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...

Part and Inventory Search

Back
Top