Search Results - Excelguru.ca

Complex calculations on a table's results

Started by gaspafter26, 2021-10-16 08:53 PM

Replies: 2
Views: 2,113

Last Post By:: Last Post: 2021-10-17 05:14 PM; by gaspafter26

Forum:
PivotTables

Calculated measure in Pivot Table

Started by fher97, 2021-06-14 02:29 PM

calculated measure, excel, pivot, pivot table, power query

Replies: 1
Views: 3,395

Last Post By:: Last Post: 2021-06-24 01:34 PM; by RET

Forum:
PivotTables

Create Multiple Pivot tables automatically or quickly

Started by MsDavid, 2021-01-17 08:17 PM

Replies: 5
Views: 3,615

Last Post By:: Last Post: 2021-01-19 10:14 AM; by MsDavid

Forum:
VBA Programming

Calculating Variances (Value and %) in Pivot (not using power pivot) - possible?

Started by Brian McGhee, 2020-05-12 11:04 AM

automate, dimension, pivot, variance, views

Replies: 1
Views: 2,797

Last Post By:: Last Post: 2020-05-12 11:48 AM; by Bob Phillips

Forum:
PivotTables

Filtering Pivot Table

Started by kaia2001, 2018-09-29 05:49 AM

custom filter, filtering, filters, format, pivot

Replies: 1
Views: 2,080

Last Post By:: Last Post: 2018-10-01 05:49 PM; by alansidman

Forum:
PivotTables

how to merge rows after pivot and group by...

Started by joe1250, 2018-04-23 06:56 PM

combine rows, merge rows, pivot, power query

Replies: 6
Views: 3,389

Last Post By:: Last Post: 2018-04-24 03:42 PM; by joe1250

Forum:
Power Query (Get & Transform) & M code

Pivot more than one column in Power Query?

Started by generalledger, 2018-02-21 09:07 PM

Replies: 2
Views: 2,211

Last Post By:: Last Post: 2018-02-22 06:36 AM; by Rudi

Forum:
Power Query (Get & Transform) & M code

sorting in pivot table without (sub)totals without grouping

Started by AleTibD, 2018-01-08 05:37 PM

Replies: 2
Views: 4,095

Last Post By:: Last Post: 2018-02-12 08:32 AM; by AleTibD

Forum:
PivotTables

I need help with pivot table

Started by TuanPham, 2017-12-17 08:23 PM

Replies: 1
Views: 3,639

Last Post By:: Last Post: 2017-12-18 09:33 AM; by Pecoflyer

Forum:
PivotTables

Default cannot drag fields to pivot table

Started by jalea148, 2017-07-31 05:28 PM

Replies: 4
Views: 6,338

Last Post By:: Last Post: 2017-08-06 01:44 PM; by p45cal

Forum:
PivotTables

Reporting Items in every month they were open, based on creation and closure date.

Started by The_excell_initiate, 2017-04-05 12:54 PM

date difference, date interval, pivot, table

Replies: 1
Views: 2,634

Last Post By:: Last Post: 2017-04-10 11:44 PM; by p45cal

Forum:
PivotTables

External Data Connection

Started by The_excell_initiate, 2016-05-06 03:26 PM

Replies: 1
Views: 3,066

Last Post By:: Last Post: 2016-05-26 10:08 AM; by The_excell_initiate

Forum:
PivotTables

Pivot Filtering by Dates

Started by b19upj, 2016-02-11 12:42 PM

Replies: 2
Views: 3,291

Last Post By:: Last Post: 2016-02-11 01:35 PM; by b19upj

Forum:
PivotTables

Timestamp to Pivot table case count

Started by Vankootens, 2016-01-11 02:37 PM

chart, count daily cases, pivot, timestamp

Replies: 0
Views: 3,098

Last Post By:: Last Post: 2016-01-11 02:37 PM; by Vankootens

Forum:
PivotTables

Pivot table showing results from multiple source columns

Started by NiranNiran, 2015-11-19 10:13 AM

Replies: 1
Views: 3,033

Last Post By:: Last Post: 2015-11-23 09:21 AM; by NiranNiran

Forum:
PivotTables

Pivot table showing results from multiple source columns

Started by NiranNiran, 2015-11-19 10:05 AM

Replies: 0
Views: 2,759

Last Post By:: Last Post: 2015-11-19 10:05 AM; by NiranNiran

Forum:
PivotTables

Getting the counts from multiple filters to use within pivot

Started by Peaklander, 2015-09-23 08:41 PM

Replies: 4
Views: 4,448

Last Post By:: Last Post: 2015-10-09 08:27 PM; by garfield101

Forum:
PivotTables

Excel 2013 PivotTable Fields Range References

Started by Luc2014, 2014-11-08 12:11 PM

Replies: 4
Views: 4,732

Last Post By:: Last Post: 2014-11-09 11:58 AM; by Luc2014

Forum:
PivotTables

PivotTable Fields Range References

Started by Luc2014, 2014-11-08 11:55 AM

Replies: 0
Views: 2,625

Last Post By:: Last Post: 2014-11-08 11:55 AM; by Luc2014

Forum:
PivotTables

I think I need Pivot Tables for Equipment Inventory?

Started by ramkiller1, 2014-07-23 10:25 AM

Replies: 1
Views: 3,107

Last Post By:: Last Post: 2014-07-23 12:22 PM; by Bob Phillips

Forum:
PivotTables

Pivot tables with diferent Value Field settings from the Subtotal field

Started by abv14, 2013-01-16 10:08 PM

Replies: 3
Views: 4,564

Last Post By:: Last Post: 2013-01-18 05:45 PM; by Ken Puls

Forum:
PivotTables

Changing format for grouped hours.

Started by Armando L Franco, 2011-08-17 03:33 PM

Replies: 5
Views: 8,045

Last Post By:: Last Post: 2011-08-18 05:03 PM; by Ken Puls

Forum:
PivotTables

GETPIVOTDATA with multiple data_fields

Started by Bendy, 2011-04-08 03:36 PM

cell reference, data field, getpivotdata, multiple items, pivot

Replies: 9
Views: 46,415

Last Post By:: Last Post: 2011-04-18 09:54 AM; by Bendy

Forum:
PivotTables

Search:

Search: Search took 0.00 seconds.

Complex calculations on a table's results

Calculated measure in Pivot Table

Create Multiple Pivot tables automatically or quickly

Calculating Variances (Value and %) in Pivot (not using power pivot) - possible?

Filtering Pivot Table

how to merge rows after pivot and group by...

Pivot more than one column in Power Query?

sorting in pivot table without (sub)totals without grouping

I need help with pivot table

Default cannot drag fields to pivot table

Reporting Items in every month they were open, based on creation and closure date.

External Data Connection

Pivot Filtering by Dates

Timestamp to Pivot table case count

Pivot table showing results from multiple source columns

Pivot table showing results from multiple source columns

Getting the counts from multiple filters to use within pivot

Excel 2013 PivotTable Fields Range References

PivotTable Fields Range References

I think I need Pivot Tables for Equipment Inventory?

Pivot tables with diferent Value Field settings from the Subtotal field

Changing format for grouped hours.

GETPIVOTDATA with multiple data_fields