Sales By Month

[#1]

HI Experts

In my Qvw I having Sales data for two Months April & May and 2 Branches

My requirement is to show top 10  With Max Sales For each branch

But if  I select May my Condition Working, but Not working for April

Got Stuck With This, Please Help

[Anonymous]

Hi,

You have the option to restrict the top 10 in the dimension limits area.

However it looks like we don't have 10 Customers in April

Check and let me know

Regards

Jeba

[buzzy996]

u can also try with dimension limits tab options,for the same..u can achieve the same result and simply way instituted of wring code in backend.

[#4]

Hi Dass

I want to choose Top Max 10 sales for each branch in April

[Anonymous]

pls check this one and confirm

[#6]

Hi Shiva

I tried that, but not working as expected, so using this way

My actual requirement was choose 200 Top Highest Sales for each Branch

and Show worst 20 sales from that 200 list

[ramoncova06]

you don't have any data for March, therefore whenever you select April the "Last Month Sales" is not showing anything

[#8]

[#9]

Hi Ramon

There are actually 30 transactions for April in that Excel Sheet

[Anonymous]

Are you using the same excel file.

Because your datamodel shows only 20 rows total !!