aggregated

  1. A

    How to make a DAX measure NOT to re-calculate on aggregated levels?

    I have a DAX measure which works perfectly on the level 0 POV in the Pivot Table but I was wondering if there is a way to make it aggregate like a regular number when filtering to top level POV (e.g. instead of looking at July or August, look at Year Total)? The problem is the aggregated number...
  2. G

    Pivot Table for Student Data?

    Hi there. I'm trying to find a way to do something for teachers in my school district. They would like to see testing data from several different platforms aggregated by student. The issue I'm facing is getting the Pivot Table to aggregate the scores by Student ID but show only one instance...
  3. A

    Disaggregating data

    Hello Does anyone know VBA code to transform X into Y? <colgroup><col width="64" span="3" style="width: 48pt; text-align: right;"> </colgroup><tbody> X F Y 1 1 1 2 2 2 3 1 2 3 </tbody> Regards António Teixeira
  4. A

    Sync query results back to initial file after updates

    Hello all, I have a directory that contains monthly lead reports - one Excel spreadsheet per month. I have an aggregated spreadsheet that takes all the data from each of the monthly spreadsheets to show all the data for all months. I do this by using the "get data" -> from file -> from folder...

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
Back
Top