How to create a dimension value which is "Total" and give sum sale for few selected Dimesion Value ?

[shekhar_analyti]

Hi All ,

How to create a dimension value which is "Total" and give sum sale for few selected Dimesion Value , on the fly without changing load script ?

Whatever Item user selects it should be added in Item as dimension value plus and additional dimension value called 'Total'

which should have sum of the sale value for all the item selected by User .

Something like this

Thanks & Regards

Shekar

[prat1507]

Please see the attached app.

Regards
Pratyush

[shekhar_analyti]

Hi Pratush ,

You have used load script . That is something which i do not want to use as per my requirement .

Shekar

[sunny_talwar · Accepted solution]

What is wrong with the embedded Total mode?

[pradosh_thakur]

hi

find the attached . Another way by not using load script or total mode.

regards

Pradosh

[shekhar_analyti]

Hi Sunny ,

That was one way to solution . I was wondering if there was another way .

But in this setting , Total is precisely not appearing as part of Dimension value .

While i was trying to replicate this scenario which is present in some other BI tool in which developers made Total as part of dimension value .

Thanks Again .

Shekar

[sunny_talwar]

In that case a slight modification in the script will be needed to make this possible... I tried with ValueList(), but that did not work...

[pradosh_thakur]

did you try this shekar ? let me know if it worked for you.