Loading Fields as variables ( Data Model)

[vikasmahajan]

Dear all,

I have 3 tables loaded using Qualify prefix , Following are my data model along with 3 tables , i loaded excel file with some fields which i want to use as a variables for displaying cost of each opportunity.

=sum(vInititiavtiveCharges)

vInititiavtiveCharges - I want to calculate each opportunity sum as per user selected in list also i have 4-5 fields as variables i want to use in my dashboard please suggest how to achieve this ?

Store each opportunity amt into Variable and show total dynamically.

Many Thanks

Vikas

Message was edited by: vikas mahajan

[tresesco]

Couple of points:

• The sample data is not having all the possible associations. E.g. - No relative Cost Center in the table NPRDBKP table, so your expected output (at least for this data set) is not legitimate I guess.
• You probably need to revisit and correct the data model.

[sujeetsingh]

As I think you can use a simple expression for the variable which changes on selection at dashboard.

[vikasmahajan]

Sorry i have corrected data model and attached the same now  i want the monthly charges total for each initiatives as per user selection in text box

SUM( NonPrdBkp.Monthly Charges) in text box if user select non prod backup ,

Sum (BKPPRD.Monthly Charges)  in text box if user select prod backup ,

Sum (NASBKP.Monthly Charges)  in text box if user select NAS backup

Hope this is clear now ?

[vikasmahajan]

Thanks i can not hard code for 20 opportunity here in sample i have only 3 opportunity but like this i have more than 50 + opportunity to code. So i have loaded all fields into excel and by loading this excel i want to show total of each opportunity dynamically as per user selection in list box.

Vikas

[tresesco]

I suggest to Correct the data model, may be like: Concatenate all three NAS, PROD, NPROD into one table and use a flag to distinguish them like:

Final:

Load    * , 'NAS' as Flag From <NAS>;

Load    * , 'PRD' as Flag From <PRD>;

Load    * , 'NPRD' as Flag From <NPRD>;

And then in the front end use this flag as selection and expression like: = Sum([Monthly Charges])