Filters

[Anonymous]

Hello Friends

I have 5 units where 4 units are different like A,B,C,D But 5 unit in Z=(A+B+C+D) you can say consolidated

which i have kept in filter

so i want when i click on Z i want to select rest all A,B,C,D but not Z in filter ..

Thanks In Advance

[agigliotti]

your explanation is not clear.

what's your needs and your expected result ?

[Anil_Babu_Samineni]

May be create like?

Only({<FieldName = E(FieldName)>} units)

[anat]

Hi Girish,

can you please provide sample data.

[Anonymous]

BU	Actual	Budget
A	10	20
B	10	20
C	20	10
D	30	10
E(A+B+C+D)	70	60

i have many records i have filter where BU is there

but when i select E i want to select A,B,C,D BECAUSE the data is incorrect or u can say they have many more BU but they have not shared but they want E also but when in selection they want E to select but to display data of A,B,C,D in table or bar chart

hope i am clear now

[agigliotti · Accepted solution]

you can do something as below in script:

load

BU,

Actual,

Budget,

BU as BU_new

from your_table where BU <> 'E';

concatenate
load distinct

    BU,

    'E' as BU_new

from your_table where BU <> 'E';

and use the new field BU_new in filter.

[anat]

Hi Girish,

check @Andrea method is working