Forum Discussion
Insert Date Field in the Market Data table
Hi Anonymous ,
We can use pivot to meet your requirement
1. Select All the budget and current fc columns, then pivot them
2. Replace the “Current FC" with "Current_FC" to make split more easier
3. Split Attribute column with space
If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that you have shared.
Best regards,Hi Anonymous ,
We can just put the fields into line chart as following after pivot to meet your requirement:
Best regards,
Community SupportHi Anonymous ,
Sorry for our late reply, We can use ctrl to multi choose the column, After pivoting the columns selected above, they will not remain in the original table, if you want to keep the origin table, we suggest you to duplicate one, If the new record is row, it will be pivote after each refresh, but the new column might need to change the query.
Best regards,
Hello v-lid-msft
Thank you very much!
I was able to do it. However, that leads me to another requirement now. How am I going to create a line chart to show the budget and current forecast for each year(2020 - 2036)? Or this even possible? Do I need to calculte the budget and forecast for each year?
Regards,
JorgeAbiad
- v-lid-msft
Hi Anonymous ,
We can just put the fields into line chart as following after pivot to meet your requirement:
Best regards,Hello v-lid-msft,
Thank you for all the support you have provided so far.
I have a new requirement which I think seems to be a bit complex. In the matrix below, there are years when there is data for the budget. The deviation for each year between budget and forecast is required.
I'm not sure if the simple Current Forecast - Budget will do the correct calculation considering there are null values in the Budget row. My question is how to get the correct deviation or difference>