groupby

  1. LearningByDoing

    GROUPBY + Slicer

    Hello, I am currently experimenting with the combination GROUPBY + Slicer, as Mike Thomas shows in the video on YouTube, but my combination is not working as desired. Maybe I just have tunnel vision and don't see the ‘problem’. Hence my request for help. Below is the screenshot with the slicer...
  2. C

    Power Query Merge rows with some duplicate data

    How to merge rows in Power Query if some columns are duplicate. Unfortunately I can't post an example, but the data I'm working with first needed the Pivot Columns function performed to move toward columnar data structure. The result is that I have multiple rows for the same metadata, with other...
  3. F

    Group By SQL Query

    Hi guys, I am getting "SQL command not properly ended" with he below query, any idea what I'm doing wrong? SELECT Bal_Dte_ID, EQ_Branch_Name, Acct_Curr_Cde as Bal_Curr_Cde, VALUE_BAL as SUM_BASE_BALANCE, VALUE_BAL_USEQ as SUM_USD_BALANCE From dwrpt.T_Risk_Merge where (Bal_Dte_ID>='20180401'...
  4. M

    How to create a group-by sum grouped by a date column?

    My worksheet has the following structure: Date Amount 4/9/2015 28.5810426 4/9/2015 114.3087462 4/9/2015 428.638518 4/23/2015 28.5803476 4/23/2015 114.3097186 4/23/2015 428.6390738 4/24/2015 169.02827915 I want a function that will allow me to create two more...

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