Regarding CRM Reports
I have this kind of scenario:
In one report the data must come in this fashion:
If customer budget is selected then corresponding category must be displayed.
If customer category revenue is selected then in category column it must display single tender or multi tender etc.
so,what should be done in query designer or where exactly changes have to be done.
Awaiting experts solution.