cancel
Showing results for 
Search instead for 
Did you mean: 

Help with merging Excel data with BEX Query

Former Member
0 Kudos

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 🙂

Accepted Solutions (0)

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Kudos

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.