Pick and Match

[posywang]

Hi,

I used Pick and Match function for the attached sample QVW but looks like the total line for Resp Code is blank. Is there a way to show correct amount? Thanks!

[vishsaggi · Accepted solution]

Check this?

Just use this in your expense expression as

= Sum(Aggr(pick(match([Resource Type],'Contractor','GSO','EMP'),

sum({<Measures={'Actuals'},[Resource Type]={'Contractor'}>} Value),

sum({<Measures={'Actuals'},[Resource Type]={'GSO'}>} Value),

sum({<[Resource Type]={'EMP'}>} Census))

, [Resp Code], [Resource Type], Resource))

[petter]