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!

Register Log in
  • Congratulations derfloh 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. Kim321

    Crosstab and % calculation

    Thank you so much LB! Your solution worked! Not that I'm surprised since you are a genious :)
  2. Kim321

    Crosstab and % calculation

    Thank you so much for your effort LB. I will try to implement this and get back to you soon :) Cheers, Kim
  3. Kim321

    Crosstab and % calculation

    Account is just one field as shown in OP.
  4. Kim321

    Crosstab and % calculation

    Thank lbass, Rows are accounts (Sales Revenue, GST, Cost of Sales, COS adjustment, Margin, Margin %, etc.) Column is Month of the year Summary field is "Value", which can contain both $ values and percentage. And yes I meant "but we canNOT sum it from the detail level"...
  5. Kim321

    Crosstab and % calculation

    Hi, This is similar to my previous issue with calculating percentage in a crosstab, but that solution doesn't work for me now :( I need to create a report with a crosstab. The report has a selection on wether to see the data on order detail level or on summary level. The data we are reporting...
  6. Kim321

    Cross tab with percentage and sub totals

    Thanks a million for this! It works great!
  7. Kim321

    Cross tab with percentage and sub totals

    Ok, version is Crystal Reports for Enterprise 4.0. :) The non-bold rows are detail level. I made the bold ones since they are sub-totals and totals. But it doesn't matter what they are, I just need to get the report as shown. btw. I got months across the columns as well...forgot to include...
  8. Kim321

    Cross tab with percentage and sub totals

    Hi, I'm trying to create a cross tab with the following structure: State Product Revenue Margin Margin% --------------------------------------------------- State1 Product1 1000 200 20% State1 Product2 2000 500 25% State1 Product3 0...

Part and Inventory Search

Back
Top