% of grand total in cross-tap

[Former Member]

Hi all

Do you know how to compare the summarize field with the total in cross tap? How about  the grid function\ GetTotalValueFor ?

Is it the correct function I need to use?

I have to add one more column next to 2012 and show the value=

895.4/5617.81=15.9%

895.4/5617.81=15.9%

0/5617.81=0%

It is appreciate for any idea.

Thank you

Cheer

[abhilash_kumar · Accepted solution]

Hi Gary,

I hope you're using CR 2008 or higher. Here's how you can do it:

1) In the Preview Mode, right-click the last column header (2012) and select 'Calculated Member' > Insert Column. A column with a blank header and zero values comes up.

2) Right-click the blank column header and select Calculated Member > Edit Header Formula. Give this column a name

3) Next, right-click one of the zero values in this column and select Calculated Member > Edit Calculation Formula. Type this formula:

(gridvalueat(CurrentRowIndex, CurrentColumnIndex-1, CurrentSummaryIndex)/GridValueAt(0,0,0))*100

To show the percentage sign, here's what you need to do:

1) Right-click the summary field and select Format Field > Common tab > click on the formula button beside 'Display String' and use this formula:

if CurrentcolumnIndex = 3 then totext(CurrentFieldValue)&" %"

else

totext(CurrentFieldValue)

This will show the percent sign only on the summary fields. To show the percent sign on the Grand total as well, use the same formula on the total field.

Let me know how this goes!

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash

Perfect and precisely.

Thanks

Gary

Gary

[abhilash_kumar · Accepted solution]

Glad it works Gary!

-Abhilash