Hi guys,
I`m working on one project that the client needs to see their expense by month, the total Year to Date and the per cent of each expense by year to date. As an example below
Expense |jul-18 | ago-18 | set-18 |out-18 |nov-18 |dez-18 |Total YTD | % YTD
DRILL |$ 1.00 | $ 4.00 | $ 1.00 | $ 4.00 |$ 1.00 |$ 4.00 |$15.00 | 24%
STAFF |$ 2.00 | $ 5.00 | $ 2.00 | $ 5.00 |$ 2.00 |$ 5.00 |$21.00 | 33%
IT |$ 3.00 | $ 6.00 | $ 3.00 | $ 6.00 |$ 3.00 |$ 6.00 |$27.00 | 43%
Total |$63.00
To do that I`m using matrix visualization. However, when I included the measures it appears the value and value YTD by each month as an example:
Expense | jul-18 | aug-18 | sep-18 | oct-18 | nov-18 | dec-18 | Total YTD|% YTD
| Value | YTD | Value | YTD | Value |YTD | Value | YTD | Value | YTD | Value |YTD | Value | YTD
DRILL |$ 1.00 |$ 1.00 |$ 4.00 |$ 4.00 | $ 1.00 |$1.00 |$ 4.00 |$4.00 | $ 1.00 |$1.00 |$4.00 |$ 4.00 | 15.00 | 24%
STAFF |$ 2.00 |$ 2.00 |$ 5.00 |$ 5.00 | $ 2.00 |$2.00 |$ 5.00 |$ 5.00 |$ 2.00 |$2.00 |$5.00 |$ 5.00 | 21.00 | 33%
IT |$ 3.00 |$ 3.00 |$ 6.00 | $ 6.00| $ 3.00 |$3.00 |$ 6.00 |$ 6.00 |$ 3.00 |$3.00 |$6.00 |$ 6.00 | 27.00 | 43%
Total 63.00
I`m struggling to find out one solution that matrix makes the calculation of the % only on the last collunm as the following example:
Expense |jul-18 | ago-18 | set-18 |out-18 |nov-18 |dez-18 |Total YTD | % YTD
DRILL |$ 1.00 | $ 4.00 | $ 1.00 | $ 4.00 |$ 1.00 |$ 4.00 |$15.00 | 24%
STAFF |$ 2.00 | $ 5.00 | $ 2.00 | $ 5.00 |$ 2.00 |$ 5.00 |$21.00 | 33%
IT |$ 3.00 | $ 6.00 | $ 3.00 | $ 6.00 |$ 3.00 |$ 6.00 |$27.00 | 43%
Total |$63.00
Can you guys please help me?
Thanks and have a great day.
