Display a value in a crosstable as a % value

[datanibbler]

Hi,

I have created a progress_tracker to visualize the status of the project. The absolute numbers are correct and the chart looks fine. Now I want to do the same, displaying % values - e.g. for one area (x-axis), there are four reports, two of them are done, so that should be 50%.

Can anybody lend me a hand here? For some reason, the relative values are garbage.

Thanks a lot!

Best regards,

DataNibbler

[Gysbert_Wassenaar]

You'll need to use the total keyword in your expression I think.

sum(Amount)/sum(total Amount) will calculate the % of the total over all dimensions of the chart.

If you need the percentage over a specific dimension(s) you'll need to include the dimension name(s) between < and > characters. For example sum(Amount)/sum(total <Product> Amount).

[#3]

This is working and so simple..Thnx Gysbert