How to make my Table Total amount display same value when my dimension change from COMPANY TO SOURCE ?

[paulyeo11]

Hi All

My objective is to see sales increase by country.

My table 1 when click on Button 1 , Dimension = COMPANY. the report shown correctly.

2015 DISPLAY 6,090 AND 2016 DISPLAY 103,212

But when i change to dimension to SOURC by Click on Button 2. HOW TO MAKE 2015 DISPLAY 6,090 AND 2016 DISPLAY 103,212 , Now it display wrong value.

Paul

[paulyeo11]

my QVW

[tamilarasu]

Paul,

I guess, the values are correct. If you change the dimension, the expression calculates sales for the particular dimension. Are you sure the values are wrong.? Are those companies are belongs to source TDSPG.

[paulyeo11]

Hi Tamil

when i click on Button 1 , Table 1 Display LY Toal 6,090 and YTD 103,212. it is correct.

My question is when i press on Button 2 ,

So how to make Table 1 display LY Toal 6,090 and YTD 103,212,

Now it display 76,991 and YTD 110,109. Because it does not take into consideration of those sales increase customer.

it display all total sales include sales drop customer amount.

Paul

.