Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I have created user driven report in which I require to add AutoSum functionality like Excel.
Is it possible?
please help
user driven report mean adhoc reports? then creat one more expression as metrix for auto sum
yes Adhoc report,
how can I create metrix for auto sum??
hi jagan thanks for your feedback,
but I want to integrate it in Pivot table bcoz I need slice and dice feature as well.
Hi,
This works in Pivot table too, just convert Straight table to Pivot.
Regards,
jagan.
No jagan I have check it is not showing totol sum in case of pivot table..
Hi,
Yes, you will get only Expression Sum, to overcome this you can try like this
Sum(Aggr(Sum(Measure), TableDim1, TableDim2,.....)
Hope this helps you.
Regards,
Jagan.