Skip to Content

Help with merging Excel data with BEX Query

Jan 18, 2017 at 02:31 PM


avatar image
Former Member

I have a requirement to chart by year the quota vs sales by Division.

Quota AND Sales information from 2010 to 2015 is based on an Excel data source. I only want to use BEX query to display 2016 sales.

I have a variable called "Won Count" which counts the sales in CRM

=Count(If ([Status])="Won" Then [Opp].[Transaction Number])

I have a variable called Actuals which counts the 2016 data and uses Excel for the rest:

=If([Year]=2016) Then [Won Count] Else [Actual]

My goal is to get it to where when a Sales Division is selected, that it shows the quota and actuals for that sales division, however I keep getting multivalue unless I also put the year in

I hope that explains the situation, please help :)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jan 18, 2017 at 02:45 PM

Then drag the Year in the table and if you don't want to show then right click and hide the Year dimension.

if it not right then share how many objects are in both queries?which objects are merged?

Plz share your table scrrenshot.

10 |10000 characters needed characters left characters exceeded