aggregation

  1. nikio8

    pq, Group by all columns

    Hi all, thanks for your help in advance Essentially i have a spreadsheet I would like to minimise rows imported from the server, using group by. Group by date could compress data down to 5%. However I have around 30 columns and in one file more than 60. It is a bit tedious and error prone if...
  2. kpasa

    Preferred Method to aggregate daily data

    Hello Community! I'd like to get your thoughts on how I should approach a new project. We get a daily report from one of our partners with subscriber usage stats. It comes in the form of a CSV and is only 1 day's worth of data. Our goal is to aggregate the data in order to do calculations on...
  3. P

    Bypass ‘multiple row context’ in DAX computation for Excel Pivot Table

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'American Typewriter'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'American Typewriter'; min-height: 14.0px}span.s1 {text-decoration: underline}span.Apple-tab-span {white-space:pre}</style>My original relational...
  4. A

    HLOOKUP: List Aggregation

    Hi, I could probably solve this in VBA, but there's got to be a better way to do this in Excel. I'd like collect every instance of an entry in list A, that appears in list B (with its search criteria), and put it in a results table, as shown below. For example:
  5. F

    Dynamically building Pivot Table with VBA

    Hi I am currently building an Excel VBA reporting project . One requirement is for there to be a Pivot Table, which can be built dynamically/change it's fields depending on the source data. It's all going well so far, but I have a problem as follows: My Pivot table variables are as follows...
  6. S

    One To Many Relationship

    I am looking for a single formula that will aggregate data for a parent group with a one to many relationship. Imagine I have sales by employee and I have an employee to group mapping table. My goal is to create a table with sales by group without mapping the group to the sales by employee...
  7. S

    Creating Histogram from Column of Date/Times

    Hello all! I hope this isn't one of those forever re-posted questions, but I have spent a couple of days looking over the archives on this site, as well as experimenting with Excel 2007, and am coming up a bit short. Simply put, I would like to take a column of date/time strings, for example...
  8. K

    Chart data aggregation & date/time formats

    I'm trying to plot a dataset of frequency of events (=frequency(values,bins)) with timestamps in a chart, and getting some odd behavior. Firstly, my dates are in the format (yyyy.mm.dd hh:mm:ss.000) and are recognized as dates in the worksheet. But, as these dates contain both date and time...

Watch MrExcel Video

This Week's Hot Topics

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