RE:Multi select

[Chanty4u]

hi all,

tresesco

swuehl

Marco Wedel

i have two multi box ....and one stright table

level2   and def-seviority

prj1                    critical

prj2               major

prj3               minor

lik dat i hve.... when i select  in prj1 and    critical and minor   from both the multiboxes...... i need extra colum in pivot table  as

sum of the both selcted critical and minor as well...total count of  prj1 ?

how can i achieve this?

thanks in advance 

Suresh

[tresesco]

Not quite clear. Could you explain a bit more?

[karthikeyan1504]

Hi,

your question is not clear, but I am giving the solution on my understanding of ur question... correct me if i am wrong.

In pivot table, add the expression sum({<prj1={'critical'}, prj2={'minor'}>} value)

Then enable the conditional option for the expression and write the expression as below,

Getselectedcount(prj1)=1 and getselectedcount(prj2)='minor'

[Anonymous]

on the selection of prj1, critical and minor only you want?

or for any selection?

[ahmar811]

try this it will help you

[Chanty4u]

thnx karthikeyan..

count({<level2={'Project1','Project2','Project3','Project4','Project5'}>}Def_ID)

count({<Def_Severity={'1-critical','2-Major','3-Minor','4-Cosmetic'}>}Def_ID)

i ried this exp..its wrkng fine..

but... in pivot table the order of Def_severity not in order 1,2,3,4....it shwng 1,4,2,3

[Chanty4u]

yes,...whatever the selection i need sum and total

[tresesco]

[Chanty4u]

i tried but its n wrkng bro....

[tresesco]

I have given the screen shot from your sample qvw only.