Hi Friends,
I've 3 columns in a report I created 3 data Items and Grouped all of them.
1. # of Products per Region, per Country and Total # of Products to be shown for Region and Country as a seperate line Summary line
2. # of Products Sold per Region, Per Country and Total # of Products sold to be shown for Region and Country as a seperate line Summary line
3. Calculated column from above 1 and 2. and I'm displaying this as a Percentage with 0 decimals.
(Total # of Products Sold (per Region, Per Country) / Total # of Products (per Region, per Country))
The 3rd Column - It displays the calculation for line items but not for Summary line.
How should I be doing this? Please let me know how to resolve this.
Thanks,
KBasha