View data in a bar chart

[Jardinillo]

Hello,

In a graphic, for example, of bars, when you click with the right button and choose "View data". In the table that shows you can you make a total sum of the values? Thank you

[Zhandos_Shotan]

No, View data and Export table shows only values that represented on chart. But using some tricks let you achieve that with limitations, i think.

[Jardinillo]

And what would be some of those tricks? 🙂

[Zhandos_Shotan]

Ok!

1. You need to create real Total bar. Add 'Total' row in your dimension in script.

2. Add expression:
if(Dim<>'Total',
Sum(Value)
, Sum(Total Value))

OR

If you need to show totals only in view/export table, you need to make totals bar color as Background color and Total row must be empty string.
See pic below and expression:

Color expression:

if(Len(Categ)>0,
LightBlue()
, White())

Check attachment

Best regards

[Jardinillo]

Thank you very much for the reply.