Thanks Pooja! super. now it is working but when I added profit ratio and for which I need to show grand total is showing wrongly
I am not able to attach that file as not getting attach option..
but what I did is created one calculative field as profit ratio=
and double click but this field is coming wrong
When you double click the ratio field that you created it will show up as zero. You will need to change the default properties of the number format. Right click on the calculated field you created and change the number format to show atleast 2 decimals. On the pop up that opens after you select number format - choose number(custom).
Yes it working now but have grand total is not summing which is wrong and that column always coming first when I double clicked.
if you do not mind can you provide me your contact no or mail id
Yes now both are working...
salute to your knowledge..
This is my last question after that I may close this thread
suppose I want to calculate Sale % which is grandtotal of sales/individual sales * 100
then how I will calculate
You can create a calc as shown below:
and you will need to change the number format of that calculated field like I explained in my earlier post (but this time select percentage) and make it to 2 decimal points to be precise, you can leave it to zero decimals as well.
Another way to do it is, to go to analysis tab and do the following:
But this will give you percentage of total for all measures on the view. To do it for a measure individually, follow the first approach.