total grouping expression

[kunkumnaveen]

Hello,

          i am getting different  total spend value  before selecting any material and after selecting ,the values i am getting  after selection is correct values

before selecting any material  all the total spend is wrong

after selecting material the total spend is correct

expression i wrote for total spend is

Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},[FISCAL YEAR]={$(=max([FISCAL YEAR])-1)}>}total<New_Column,[PLANT NAME]>SPEND)

New_Column labeled as Material

i think something is going wrong in my expression .How to make same values to appear even before selecting any material as i am grouping with material and plant name

thanks

[Anil_Babu_Samineni]

What are you selecting here? I wonder where you are doing this type of magic charts. Will you able to provide application to check?

[kunkumnaveen]

Hi  I just took screen short and cut only to get tables

The second pic has selected material

[Anil_Babu_Samineni]

In fact, there is no any wrong in set operator. But, I would ask you to copy and paste same expression until you provide sample application

[kunkumnaveen]

Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},[FISCAL YEAR]={$(=max([FISCAL YEAR])-1)}>}total<New_Column,[PLANT NAME]>SPEND)

New_Column labeled as Material

[kunkumnaveen]

Only one thing I want to known the total spend which I am getting after selecting a material pic2 will it possible to get same values for that material even before selecting that particular material,is there any alternative way to write this expression

[Anil_Babu_Samineni]

Some how you used correct one only as i feel, Even Label names we can't take it as straight forward. And that do you get any error over expression. I am not?

[Anil_Babu_Samineni]

May be, Would you like to provide sample work file