Qlik Sense: Total value on table without one column

[surtex]

Hey Qlik Member,

i have the following problem: 

I would like to show the YTD Value without the Monthly Plan Column and if possible I like to show the YTD Value (Total) on the right side. 

Can i write an expression for the total value in a table or should I create a seperate total field (YTD). If I must create an seperate field, how would you go about it?

The table:

The Dimensions and Measure:

Thank you 🙂 

[Or]

Assuming your formula for EBT is something like Sum(EBT), you could try using something like:

if(Count(distinct Monat)>1,Sum({<Monat -= {'Monthly Plan'} >} EBT), Sum(EBT))

[surtex]

Where should I write this expression? Because the total field adds up automatically in the background.

[Or]

This would replace your existing expression (which in my example was Sum(EBT) but might be something else entirely, in which case you'd need to adjust accordingly)

[surtex]

Oh okay, I understand. 

The function does not count for this or? Is there a way to store a calculation for this "Total" button or do I have to store YTD as a dimension in the calendar and facts data??

[Or]

I'm sorry, I don't understand that last question (and I don't speak German so the screen capture doesn't help).

[surtex]

I have activated the field Show Total value on dimension month in the pivot table (the values below YTD). I have named the total values (YTD). You can understand me now? 🙂 

[Or]

I'm afraid I still don't understand what you are asking.

The expression I suggested simply counts the number of months, and applies a different sum if the result is 1 (which means we're within the context of a single month, so not a total) or if the result is more than 1 (which means we're inside the total since the inner part of the pivot is always specific to one month). It replaces the previous expression that you were using. This doesn't have anything to do with enabling the total, picking out a label for the total, or anything of that nature.