TIBCO Spotfire

Hi,

In Cross table i don't know how to do the sum of unique value of a column which i need as Column value in cross table.

Column has period hierarchy and vertical axis has another hierarchy.

 Product    Date                Cost          Expected    Category

     A          1/2/2010        100                 80             1

    B            1/2/2010        50                 80              1

    C            2/2/2010        50                 30             2

I want in my cross table expected column value as 80 with Product count 2 for vertical axis Category 1, currently it displays 160 as expected and product count 2

I tried with rank, but rank is not dynamic to recalculate based on date hierarchy.

Please help me out.