cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic selection of Analytical view in Calculation

Former Member
0 Kudos

Hi

Is it possible to dynamically select the view based on Cases statement.

Myscenario

I have to show the actual sales and projected sales.

Every month, the showroom sends the actuals sales and the projected sales.

Ex.

ShowroomJan 2016Feb 2016Mar 2016Apr 2016May 2016June 2016July 2016Aug 2016Sep 2016Oct 2016Nov 2016Dec 2016
SHW - 1200300400500500400300350500400300200

In Month of Feb , Jan and Feb will be actual sales and march to december will be projected sales

Some months, the same showroom may not send projected sales, but actual sales only

Ex In month of april, the showroom has send only Actual sales till Apr 2016

ShowroomJan 2016Feb 2016Mar 2016Apr 2016May 2016June 2016July 2016Aug 2016Sep 2016Oct 2016Nov 2016Dec 2016
SHW - 1200300400500

So when we run the report, I should take the previous month Projected sales and need to apply for remaining months

In this case, I need to take March data which has projected sales from Mar to Dec and I need apply from May to Dec

So,

The possible thought is , will create projection for last month, and current month and if the projected months value is empty I need to take from other projection (ie last month)

Sometimes, it may be case, the projected sales they might have given only one time , so I need to traverse back to find the month where the projected sales exist and to take projected sales from those and apply in report

Coming back to question, is it dynamically I can select the projection I need to report based on condition

Ex.

if curr month projected sales exist

take proj 1

else if month-1 projected sales exist

take proj 2

else if month-2 projected sales exist

take proj 3

-

-

-

else if month-11 projected sales exist

take proj 12

Regards

Ben

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

hello Experts,

Any input pls

Regards

Ben

former_member230931
Participant
0 Kudos

Not sure if you need a dynamic view selection, broadly I would assume you design a solution based on two analytical views

1. actual sales

2. projected sales

Join the two together in calculation view using UNION

resulting view can be used to define the logic for actual sales and projected sales when actuals are not entered.