Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please see the attached app.
Regards
Pratyush
Hi Pratush ,
You have used load script . That is something which i do not want to use as per my requirement .
Shekar
What is wrong with the embedded Total mode?
hi
find the attached . Another way by not using load script or total mode.
regards
Pradosh
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
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...
did you try this shekar ? let me know if it worked for you.