Hello there,
I am using set analysis on most of my reports but I have come across the following issue:
- How can I replicate the result of this formula "Sum(qty)/Sum(TOTAL<Year,Style>qty) in set analysis?
I have the following formula: Sum({<Year=,Month=>}qty) (of course the reason for using set analysis is a little more complex but basically I need to show the % per each style total besides the actual total.
any help is greatly appreciated.
Thanks,
Hugo