see the attach superstore example
Grand totals can't be used in a calculation but you can do this
use an lod to determine the yearly avg
then use that to determine the percentage
it returns this
You mentioned the values in your avg were calculated - if so you may need to make them lods also then then nest that LOD in the calculations above
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
avg percentage.twbx 2.3 MB