BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: BOBJ conference in Paris: Mar 28, PGHBOUG: Apr 4.

Break on Measure


 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
asharma2010
Senior Member
Senior Member



Joined: 25 Jul 2010

Posts: 65



PostPosted: Thu Jan 10, 2019 5:30 am 
Post subject: Break on Measure

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
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14206
Location: England


flag
PostPosted: Thu Jan 10, 2019 5:39 am 
Post subject: Re: Break on Measure

Two crosstabs relatively aligned to one another.
Back to top
asharma2010
Senior Member
Senior Member



Joined: 25 Jul 2010

Posts: 65



PostPosted: Thu Jan 10, 2019 6:18 am 
Post subject: Re: Break on Measure

Thanks so much Nick,....is there any other way...

Arun
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22124
Location: Dallas, Texas


flag
PostPosted: Sat Jan 12, 2019 3:25 pm 
Post subject: Re: Break on Measure

Moved to Web Intelligence from Semantic Layer forum, thanks
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
• 2018-09-13 Copying Content Is Not A Complement
Back to top
mikeil
Forum Associate
Forum Associate



Joined: 18 Feb 2015

Posts: 770
Location: Europe



PostPosted: Mon Jan 14, 2019 5:16 am 
Post subject: Re: Break on Measure

Perhaps pulling the data in twice and merge: use the quantity from the first, and the value from the second?
Back to top
dukesilver
Forum Member
Forum Member



Joined: 31 Oct 2018

Posts: 6



PostPosted: Wed Jan 16, 2019 6:34 am 
Post subject: Re: Break on Measure

Hi,

Can you post an excel screenshot of exactly how do you want the data ?

regards,
DS
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0329 seconds using 17 queries. (SQL 0.0031 Parse 0.0014 Other 0.0284)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo