Forum Discussion

ChiliGuy's avatar
ChiliGuy
Frequent Visitor
7 years ago

Pull Goals into a Matrix, then do calculations

I am attempting to reproduce a pivot table I created in Excel, which displays YTD sum totals by a value named "Finance Categories". I then added a few columns next to the pivot table to display the g...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi ChiliGuy,

 

"But when I create a second dataset querying the table that holds the goals, I can't seem to pull that data into the Matrix to display the goals for each Finance Category."

 

<--- Which columns have you put in your matrix? Could you share some details about your calculate column "YTD % to Goal" and your expected result?

 

Regards,

Jimmy Tao