I got a table where accounting table where
I want display matrix,
how i can do if i want display as row all account
and then have account 120-100
can i do this in querying?
Can you show an example of the output you want?
Proud to be a Datanaut!
the result must be a MATRIX:
I guess the best way to do it is by making a calculated table but i don't know how to proceed
I need to display a matrix but I need to have a calculation in the middle row of the matrix.
in the example account 120- account 130 = for month 1 ->3-4=-1
for month 2-> 6-0=6
this is how I wish to display it
regardings months I would need to display in the matrix the last 12 months running and not the calendar year
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!