Logic

[sona_sa]

Hi,

I have a pivot table, all the selection are working fine but for section selection it is not displaying selected data.

For reference please check the attached qvw.

Thanks.

[NickHoff]

Hey Akumar,

I recall coming about this problem when working with alternate states.  The solution was within the set you have to use ::.

An example would be Section1=$::Section1 inside your set.

Although it might not be clear without knowing the data below is an example of my full expression:

SUM({SetA<@Refined2IND={$(vRefined)},CalendarYear=$::CalendarYear,CalendarQuarter=$::CalendarQuarter,CalendarMonth=$::CalendarMonth,PhysicianRole=$::PhysicianRole>}Cases)

[sona_sa]

Hi Nick,

I didn't got u'r point. I would like to know is it possible in this expression or I have to make any changes on the same expression. I have attached my apps in the same, can u do something on that.

Thanks for reply.

[#4]

You have some synthetic keys. Maybe you can try getting rid of them and see how it behaves?

[sona_sa]

Hi Ajay,

Thanks for your valuable time, I know there is synthetic key, But it is working for another selection like Format / Source Name / Trans Type Name / Department / Country, Only not working for Section or Section 1.

Thanks Again.