Search results for query: *

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

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

Account is just one field as shown in OP.

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

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

Thanks a million for this! It works great!

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

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