Break on Measure

[arvshar2]

Hi Gurus, I have a requirement to display data like this

--------------------------- | Jan 2017, Feb 2017 etc |Jan 2017, Feb 2017 etc

Customer | Product | Bill Qty, Bill Qty etc | Bill Value, Bill Value etc

I tried with Cross tab but Bill Qty and Bill Value comes together. Is there a work around to apply Break on Measure or any other suggestion would be helpful. Bit urgent.

Thanks
Arun

[amitrathi239 · Accepted solution]

one option is to create two cross tabs.one with dimension objects,month year and bill qty and other for dimension objects,month year and bill value.hide the dimension objects in second cross tab and use relative position to put together second cross tab with first one.

[arvshar2]

Thanks Amit for response...did the same way...but was looking for another straight forward way if possible..