PowerPivot - Measures & Calculations - Reference sum of value for variable in column

Daugaard92

New Member
Joined
Nov 20, 2020
Messages
16
Office Version
  1. 2016
Platform
  1. Windows
Hello everyone.

I'm not good at explaining stuff, but I'll give it a ago, since I'm stuck - I've included pictures, since it's troublesome to describe in text - I hope that's okay :)

I have a data-sheet, from which I've created the pivot table shown below, displaying amongst other things "PSO"-values in "kr.".

1612528058668.png


Now, I'd like to verify these PSO-value, by comparing them to data in an alternate data-sheet from another source - And would like to show these PSO-values by month, from the alternate table, in the same table shown above - So I can easily compare the values from both sources.

The alternate pivot table has a data-structure as shown below - Each row also has an assigned month and period.

1612527954341.png


Now, in order to display it in the earlier pivot table, I'm guessing that i need to "calculate a new measure" under the headings "PowerPivot" and "Measures".
I tried doing what is shown below. As can be seen, I'm trying to identify the "SUM" of values in the database containing variable value: "PSO", in the column dubbed "Overordnet forbrugstype".


1612528419328.png


I know I'm doing two things wrong, but I don't know how to correct them.

1: I'm not specifying the "kr." value in the formula, which I'd like to aquire for each variable dubbed "PSO".

2: I'm not correctly specifying in the formula, that I'd like it to only extract the variables containing "PSO".

Might someone be able to explain, how I can solve the problem? Sorry again about the long description.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Daugaard92

New Member
Joined
Nov 20, 2020
Messages
16
Office Version
  1. 2016
Platform
  1. Windows
I think I thought up a solution myself - I can simply add a variable to both data-sheets and then make a data-connection between the two :)
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,129,478
Messages
5,636,559
Members
416,923
Latest member
jarri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top