Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to present in pivot table sum by currency, when i have dimansions vertical and the currency is horizontal, in edision I have to put a column at the end that sums all by the local currency
for that I have made a calculation in the script but how do i put that sum as one column at the end of that pivot table???
Tanks,
Ester
It looks as thoug you need to look into using the 'Show Partial Sums' checkbox on the Presention tab of the chart properties dialog - select the relevant dimension you need and check the box - a total column will be added to the end of that dimension.
Hope that helps,
Matt - Visual Analytics Ltd
Try adding an additional Expression to your Table with you calculation in it; ensure that the new expression is the very last on in your Expressions list. You should see the new column added to the end of your table.
The problem is that it makes column to every currency separately and i need it to one column to all
Matt, the calculation is in the script because every currency have a different rate so Partial Sums does not work for me