Forum Discussion

questions's avatar
questions
Icon for Helper I rankHelper I
6 years ago

How to summarize data by calculating from another table?

I have few Master Tables as below:   1. Master Raw - Show invoice details (trade lane - From & to and  date) 2. Estimate amount - Show the estimated amount of each invoice 3. Split % ...
Need Help
Tutorial Requests
questions's avatar
questions
Icon for Helper I rankHelper I
6 years ago

My goal is to show both forecasted Sales & Actual sales together into 1 table + the % of difference.

How can I eventually showing two in one?

 

 

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

Hi questions 

I have problems creating "Forecast sales" as shown.

Could you show the relationship among your tables?

 

Best Regards

Maggie