It's doable. You can put 2 worksheets on your dashboard. The first one is the 12 months row in the middle. For the second worksheet, you can create a calculated filed to determine positive NPV and negative NPV. Or you can start a calculation on the row or column shelf.
Hope it can help you
Thank you Leo for your quick reply .
I 'll try that and get back to you if any issue.
appreciate your help.
Glad to help you.
If the solution solve your question please mark it as correct answer to close the discussion.
So just to confirm 1 sheer to hold my monthly calendar and 2nd one for both positive and negative values? But in this case ho do i put + val on top of the month axis and - vals in the bott of the axis.
Sent from my iPhone
it seems not working.
i had the top sheet with months and 2n one with data but how to connect them ?