Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Totals Label

Hi Everyone,

This is probably simpler than I'm making it, but I'm stumped:

On a pivot table, Presentation tab > Show Partial Sums > Label for Totals, what's the most simplified method for including the dimensional value in the Total label? For instance, if the column is Product Category, and the dimension value is Clothing, how could the Label for Totals be made to says something like "Clothing Total"?

Thanks,

DJ

13 Replies
erichshiino
Partner - Master
Partner - Master

Actually, for a pivot table you can write on 'Label for Total' for each dimension that you enable for totals

Anonymous
Not applicable
Author

Erich,
6 points for trying... 🙂
Apparently the question was a little different. You can write lable 'Product Category', but what DJ wants is ="Product Category", so each value has it's own label. Although it is allowed to use expression here, it works only for the overall selected data, not for the table row. Not sure there is a solution.
Will follow, maybe there is...

Not applicable
Author

Exactly. And, I've tried loading a variable, but the string only works when the variable is a single value -- which effectively makes it behave like it's hard-coded. Not explicitly selecting a value, or selecting multiple values makes the string parse to NULL. 😞

agigliotti
Partner - Champion
Partner - Champion

Hello,

I need the same thing.  is there a way to achieve it in pivot table ?

azimabadi
Creator III
Creator III

HI everybody,

I have many times this problem and couldn't find any solution. today i have a new request that is the same and i tought to search in forum, maybe somebody has it already solved, but it seems that it's impossible

Not applicable
Author

Dear all,

I've also received the same request from two parties, may I know if anyone has solved this problem?

Any plan to support this?

Ivan

Gysbert_Wassenaar

See here


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert,

Thanks for your reply.  But what my client requested are the label to be dynamically changed based on the values of the previous column, such as the "Clothing Total" shown in the first post.

mountaindude
Partner Ambassador
Partner Ambassador

Any luck finding a solution for this?

Please mark the post as a solution if it provided you with a solution to the topic at hand. Thanks!