2 Replies Latest reply: Jul 19, 2012 4:08 PM by Mayil Vahanan Ramasamy RSS

    Need help with Straight table

      Hi,

       

      I have the data as attached with fields as Store,MM,Month, Sales & Year. I have defined 2 variables as vMaxYear=max(Year) and vMaxMonth=max(Month_no).

      I have seperately loaded an inline table linking the month corresponding to month_numbers.

       

      Now, I use the following expression to show the monthly data in a straight table where I took store as a dimension.

       

      Sum({$<Year={$(vMaxYear)},Month_no={$(vMaxMonth)}>}Sales)

       

      The straight table doesn't fetch any result, after I selected a MM,Year, Month from my list boxes

       

      Now, when I change this expression to =Sum({$<Year={'2012'},Month_no={'2'}>}Sales) in a text object, I can see the result.

       

      Please help me understand, where am I going wrong.

       

      I would also need to calculate YTD in this case, in the same straight table

       

      Thanks In Advance,

      Tutan