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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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