Forum Discussion

Gopal30's avatar
Gopal30
Icon for Helper I rankHelper I
7 years ago

Filtering Amount using Financial Dimension Code

Hello Guys, i am trying to create a Fiancial report with the budget and Actual amount for different product and i want to filter it based on each dimension code. You can see in the image below the value for Prusupuesto is same for each Global_Dimension_code.

 

While actual result should filter amount for the code, for eg:

 

ED903--> Amount 20000

ED902--> Amount 24827, etc. 

 

 

 

Show and Tell

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Gopal30 

    Do you have data like the first table in screenshot below?

    Then you want to show total actual amount per dimension code per month/year like the second table below?

    Best Regards

    Maggie

    • Gopal30's avatar
      Gopal30
      Icon for Helper I rankHelper I
      7 years ago

      Thanks v-juanli-msft  for the answer. However i was looking for something else and i did manage to get it working. There were some problems with the relationship between the tables.