Selection criteria

[Karim_Khan]

Hi Team,

   I wanted to do calculation for finding bookings.

Which will be like

SUM([Sales Level2/[Sales Level1])

Its a dynamic value.Pls suggest

Whenever I click on Sales Level 1 and Sales Level 2 then it should give the calculation.

Regards,

KK

jagan‌gwassenaar‌MRKachhiaIMP‌ashfaq_haseeb‌Kush141087‌

[#2]

You can show the Chart or in Text object by enabling conditional show option on the object Properties Layout.

GetselectedCount([Sales Level2]) and GetselectedCount([Sales Level1])

[#3]

Please find the attached qvw.

[Karim_Khan]

Hi,

   Suppose If I select Only Sales Level 1 Americas m then it should calculate the value which are mapped in Sales Level 2

Like CANDA,US COMMERCIAL,USA etc. and Vice versa.

If I select Only Sales Level 2  Canada then it should calculate the value which are mapped in Sales Level 1

Like Amercia Only.

[#5]

Simply change the condition to below:

GetselectedCount([Sales Level2]) OR GetselectedCount([Sales Level1])

[#6]

Find the modified qvw.

[Kushal_Chawda]

Please see the attached.

I think you need the Alternate state, But right now I have done as per your requirement.

[Karim_Khan]

Hi Kush,

    In your QVW while am selecting only Americas then it should only give American region which are

AMERICA,CANADA,LATAM,US COMMER,US ENTERP,US OTHERS AND US PS MARKET.

But in given qvd its picking the entire Sales Level 2

Regards,

Karim Khan

[Kushal_Chawda · Accepted solution]

Please see the attached

[Karim_Khan]

Once Again tnx Bro.