It will Display default value and current value

[Ramu]

Hi All,

Scenario 1:

I have fields like Region, sales information is there,and Time Dimension is there .

And I used Region as filter.

My Requirement is:

I won't select any filter it will display the default value, If I select any  filter , it will display the default value and selected value,

I used this foemula,

If(getselectedcount(Region)=0,Sum({<Region={'All'}>}Sales),Sum(sales))

Without selection it will display the default value, But If I selected any value in filter it only display the selected value, But 

I want to display the default value and selected values.

Like , if i select the APMA in Region filter , It will display the All, APMA in Line chart .

Scenario 2:

I have field like,

LOAD * INLINE [
A_Name, C_Value, C_Flage
ANA, BAC, Yes
ANA, ICC, NO
ANA, SPC, Yes
ANA, DAC, No
ANA, PPC, Yes
ANA, BAC, NO
ANA, ICC, Yes
ANA, SPC, No
ANA, DAC, Yes
ANA, PPC, NO
ANA, BAC, Yes
ANA, ICC, No
ANA, SPC, Yes
ANA, DAC, NO
ANA, PPC, Yes
ANA, BAC, No
ANA, ICC, Yes
ANA, SPC, NO
ANA, DAC, Yes
ANA, BAC, No
ANA, ICC, Yes
ANA, SPC, NO
ANA, DAC, Yes
ANA, PPC, No
ANA, BAC, Yes
ANA, ICC, NO
ANA, BAC, Yes
ANA, ICC, No
ANA, SPC, Yes
AND, BAC, NO
AND, ICC, NO
AND, SPC, Yes
AND, DAC, No
AND, PPC, Yes
AND, BAC, NO
AND, ICC, Yes
AND, SPC, No
AND, DAC, NO
AND, PPC, NO
AND, BAC, Yes
AND, ICC, No
AND, SPC, Yes
AND, DAC, NO
AND, PPC, Yes
AND, BAC, No
AND, ICC, Yes
AND, SPC, NO
AND, DAC, Yes
AND, BAC, Yes
AND, ICC, Yes
AND, SPC, Yes
AND, DAC, Yes
AND, PPC, No
AND, BAC, Yes
AND, ICC, NO
AND, BAC, Yes
AND, ICC, NO
AND, SPC, NO
];

This is my data 

Here

               BAC          DAC        ICC          PPC           SSP
ANA           4             3              3                 2              4
AND          4             2               3                 2              3

If I calculating the that displaying the in this way. These are C_Flage is 'Yes'

My Requirement is 

I want to display the top value count of each values. if two c_values count is same it will display the two values, if 3 , three values displayed like that,

I used firstsortedvalue , But not working , it 's displaying single value only , I want Max count is same it will displayed all vales.

A_Name         C_Value

ANA                  BAC,SSP

AND                  BAC

Please help me, 

thanks,

Ram

[sunny_talwar · Accepted solution]

You can try this for scenario 1

If(GetSelectedCount(Region) = 0,
    Sum({<Region={'All'}>} Sales),
    Sum({<Region +={'All'}>} Sales)
)