expression help - urgent plsss

[#1]

Hi Experts,

i have attached sample qvw.

in that i have different branches. i need to rank the branches on three categories separately and then total of these three ranks gives total points.

finally, i have to rank for this total points.

when considering monthly selection, it works fine.

but when a quarter is selected, the total points are not changing.

eventhough a quarter is selected, it gives monthly total points.

My requirement is to get branch's total points alone for quarter.

how can i do this.

pls help me.

[Marcio_Campestrini]

Hi Prrajendran

Please post an example with your chart.

Márcio

[#3]

Hi Marcio,

Pivot table is there in the sample.

just click clear after opening the qvw & help me pls

[#4]

pls someone give suggestions

[Marcio_Campestrini]

Hi

Have you solved your problem? If you did, please choose the correct answer and help us to keep community focused.

[ramasaisaksoft]

Hi Rajendran,

i am unable to find your attachment.

as per my understanding

For you better object is Pivot table only

you said issue with quarter filter can u please select Quarters in list box and un-select that time Months list box.

and please specify your expression also so that we will know how u fallowed aggregation at expression level.