Using WINDOW_SUM([Field]) Duplicates Totals when missing Values in a Window of Months

Version 1

    Hi,

    I am using: WINDOW_SUM(SUM([Total_Cost]))  the get the numbers in Red.   SUM([Total_Cost]) is the SUM in EVERY MONTH for ALL Stores of (Quantity * Retail_Price).

    It works OK, but for Item1, which has two values missing in the Window from Jan to May, an extra Total (300) is added unnecessarily as a second row in the Window Total col.

    The problem does not show for the other Items because they have values for all the months.

    Is there a tweak to get rid of this second row?, or another approach to get the Total from the Window (Jan-May)?

    Using the Totals from Analysis menu does not work, because the Columns (Price, Cost, ..) are Discreet Measures and Show Column Grand Totals DO NOT work with them.

        

    ……………..

    Columns

    Window Total

         Jan

        Feb

        Mar

        Apr

        May

    Item 1

    Div,Price,Cost..

    300

     

    100

     

    100

    100

     

     

    300

     

     

     

     

     

    Item 2

    Div,Price,Cost..

    500

    100

    100

    100

    100

    100

    Item 3

    Div,Price,Cost..

    500

    100

    100

    100

    100

    100

     

    Any help will be greatly appreciated!

    Jorge.