Pivot table problems

[#1]

Hi all,

I got 2 pivot tables that do not respond toward my selections.

1st one containing the following information:

Total km's          2..               3..               4..              5...

When i switch or select different values like only 2 weeks etc the total km's won't change it keeps showing me the total value instead of switching towards those 2 weeks. Another example if I check out  that it won't count vehicles that didn't drive more then 100> km's it still keeps them included while the other 2-5 expressions/dimensions like average km etc do respond towards my selections. Only this first box doesn't seem to respond to anything.

Expression:

=SUM({$< Year = {$(=max(Year))} >} TotalDistance)/1000

Second one

Total Revenue

2..

3..

4..

Again 2-4 do respond towards my selection while the total revenue doesnt react towards any selection'.

Expression:

SUM({$< Year = {$(=max(Year))} >} Revenue)/1000

[MK_QSL]

Dear Vincent,

Can you share your apps?

[#3]

Hi Manish,

My employee does not allow me to upload my app.

However if I change my expression towards this:

=SUM(TotalDistance)/1000

It starts responding towards my selections. So i am pretty sure it has something to do with:
=SUM({$< Year = {$(=max(Year))} >}

[MK_QSL]

But you can always create a sample apps with dummy data similar to you original apps.

Sometimes its difficult to answer without checking apps.