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]

Hi Vikas,

What is your measure and expected output?  Please explain more on expected.

[vikasmahajan]

Measure - > SUM(AMT)

Sum(Amt) for opportunity which user select from list box.

For Example

NonPrdBKp - > sum(Amt)

BKPPRD ->  Sum(amt)

NASBKP -> Sum(AMT)

As per user selection.

Thanks

Vikas

[tresesco]

I don't see any field called opportunity.

[vikasmahajan]

Initative is nothing but opportunity.

[vikasmahajan]

Please let me know any details you required ?

Vikas

[tresesco]

Data model is yours and that 'nothing but...' is obvious for you but me.

And yes, I am not yet sure about your requirement. Lets take a case: you select 'Backup Deocm - Non PROD' , what is expected output (please explain the logic as well)?

[vikasmahajan]

Thanks Tesesco , I have made little modification's in QVW and attached again following are my requirement

If user select  Backup - Non PROD from list box  then  in text box  i want to display the total amt for (Backup - Non PROD) initiative/opportunity dynamically .

7130.24 sum of amt for  Backup - Non PROD opportunity and rest accordingly as per user selections.

Thanks

Vikas

[vikasmahajan]

Still require more details ?

Vikas

[jonathandienst]

er.. and sum(Amt) does not work? In what way is it incorrect? I do not understand what the problem is.