formula is max() but need to show total on the top(total)

[alexpanjhc]

Hi

i have the following formula, but i need to sum it only on the top in a straight table, how do i do this?

max(DISTINCT{<[-TimeKey]={'$(=$(=vWalletMaxYear))'}>} Wallet)

thanks!

[Vilo · Accepted solution]

While you are in edit mode and have 'Advanced Options' selected, on the right side in the properties panel, click on Data and click the measure you'd like to change the totals function (what is displayed at the top of the field in the straight table). If you look under that a little bit you'll see a 'Totals Function' option. Select that and click 'Sum'. You should now see the sum of your measure at the top in the straight table. 

[alexpanjhc]

Thanks! this helps!

[alexpanjhc]

@Vilo 

sorry, a follow-up question,  I want to ask how can i do a distinct sum with this option?

[Vilo]

I don't quite understand. If you'd like to see distinct values you would add that to your expression editor for that measure, then when you use the sum of totals it'll be from all the distinct values. Otherwise, I don't think there is a way to add the 'Distinct' to the Totals function. 

[alexpanjhc]

using max() does not have a capability to have distinct value for each line.

there are multiple lines possible  but i only want to sum the distinct values.

does that make sense? @Vilo