Hello Community,
my first post here so please appologize when something is not like you expected.
I trie to achive to get the following:
Reporting Group | Statistics CY 2010 | Statistics CY 2011 | Statistics CY 2012 | Statistics CY 2013 | Statistics CY 2014 | Planning CY 2014 |
Income | 100.000 | 150.000 | 100.000 | 120.000 | 140.000 | 80.000 |
Earned | 10.000 | 15.000 | 20.000 | 15.000 | 19.000 | 7.000 |
income in % | 10% | 10% | 20% | 13% | 14% | 9% |
The data for income and earned will received from accesable data. Additional I want to add a line on the fly with the percentage calculation in dependency from Income to Earned.
So the data for income in % is not in any table!
I tried all sheet objects like table .... but I always ended up that I have to choose one of the existing columns.
Adding an expresion will always add the information on the end of the table. So this not what I will achive.
Is there any documentation how I can realised this?
Looking forward to your help.
Please let me know if you need further details.