how to show max date sales in tables when i had not selected year

[venkat1]

there is a pivot table gold and diamonds with two dates for gold and diamond.

now i want to write an expression for both gold and sales totals 

if no selection done on year then in table it should come sum of sales for current day,if any selection had done then it should come accordingly to the selection of fields.

[gf]

Can you share the file?

[gf]

Declare a variable for example:

vSelectedDate =if(GetSelectedCount(yourDate)=0,Today(),GetFieldSelections(yourDate))

To sum it up use: SUM( {$<Text = {'Diamond' }, Date={'vSelectedDate'}>} SALDO)

Should work.

[venkat1]

i tried it was not working