PDA

View Full Version : PivotTables



Pages : [1] 2

  1. GETPIVOTDATA with multiple data_fields
  2. Sorting PivotTable Data with Multiple Fields in the Values Area
  3. Avoiding (blank) in row label fields
  4. Changing format for grouped hours.
  5. vba program to actualice pivotTable
  6. PivotTable - Group by Customer ID or NIT
  7. Use Pivot Table Data in Formula with multilpe criteria
  8. POWERPIVOT: Unable to drill down from pivot
  9. Summarize Data using Formula or Pivot Table
  10. Automatic filtering in Pivot Tables
  11. Conditional Filtering in EXcel 2007 Pivot Table
  12. Create Pivot Table OR Chart from attached survey data
  13. Custom formulas in Pivot Table
  14. Blank Rows in Pivot Tables Help, Please
  15. Creating a Pivot Table Based on a Count Range
  16. GetPivotData (Pivot Table vs Power Pivot Table) behavior
  17. Pivot table won't recalculate
  18. Pivot Table Question
  19. Can we get this with excel pivot table
  20. Dashboard Creation
  21. sorting Report Filter Drop-Down
  22. Calculating % of sub-total instead of % of column
  23. getting 2007 pivot tables to work in 2003 excel
  24. External Data Source for multi-PivotTable
  25. Conditional formatting and expand/collapse table
  26. How to group the month
  27. Change data source
  28. Pivot Table Style design
  29. Calculated Field for year-to-month figure
  30. How to filter out records and dependency on other column
  31. OLAP Pivot
  32. Pivot Table Won't Update
  33. How to clear / update filter
  34. Password request for connecting to a protected xls file
  35. Pivot tables with diferent Value Field settings from the Subtotal field
  36. value field setting (difference from)
  37. Pivot Filed List - adding the field problem
  38. Show top 10 item
  39. Cannot SUM the value if connection by external source
  40. Pivot Chart - Hide value filed button on Chart
  41. calculating differences
  42. Connection String Data source
  43. Workbook file size cannot be reduced
  44. Remove DIV/O from cells
  45. How to match particular Data as a simple query request ?
  46. Changing tab color conditionally
  47. Filtering Rows headed by dates for specific periods
  48. Slicers
  49. count unique value
  50. Using OR condition to filter Pivot Table
  51. Summarize Worksheet
  52. Consolidating 2 tables into one table
  53. PivotTable sub-totals with zero cells
  54. Pivot Table Dropdown Updating on Fly?
  55. .PivotTable.PivotCache.MemoryUsed takes an aweful long time on large pivots.
  56. How do I get Vlookup to return multiple matches?
  57. Create VBA Pivot Table
  58. How to tranpose 2 column excel spreadsheet by column A group
  59. Need help with my calculation on 95th and 50th percentiles
  60. Updating multiple pivot tables at same time.
  61. [Solved] Grouping of dates on one pivot table impacting another
  62. GETPIVOTDATA Function
  63. Pivot Table - can't filter items in page area
  64. Best profit hour
  65. Searching a slicer
  66. help with powerpivoting from multiple tables
  67. Mysterious Measures
  68. only font color change in conditional formatting
  69. Updating a cell from a table entry
  70. Data no longer available
  71. Always sort pivot table bu last column
  72. Pivot Table formula giving incorrect results
  73. Converting Data for Databse Spreadsheet
  74. Select all fields in PIVOT table
  75. Help with a Pivot Table
  76. Excel 2007 pivot table filter question
  77. Track monthly sales for large SKU inventory
  78. Inserting a different total to a column
  79. Restricting a slicer from being edited
  80. Excel 2010: Is there a way to set default pivot table layout to 'Classic'?
  81. "Intelligent" report filter
  82. Filtering required fields in the mentioned excel Sheet
  83. Need a Report Calculating Across Multiple Columns from Different Worksheets
  84. Positioning data in single column for a graph.
  85. How to display exact values in pivote table in case it is a % data source
  86. How can I link to a large table in another excel file ?
  87. Pivot Table Subtotals
  88. Average of monthly count
  89. How to set data source for pivot table permenant even if file name or path changed in
  90. Pivot filter
  91. I think I need Pivot Tables for Equipment Inventory?
  92. Multiple columns values- mistake: repeats column 1 value counts for all other columns
  93. PowerPivot Filtering := Frustration ^10 degree!
  94. Grouping then expanding/collapsing
  95. Get Value from Pivot table.
  96. Pivots Table filter
  97. Help with custom filtering
  98. How to Minus one Running Total column from another inside Pivot?
  99. PivotTable Fields Range References
  100. Excel 2013 PivotTable Fields Range References
  101. Confusion over averages in pivot table
  102. Pivot table
  103. Copy and paste a Pivot Chart
  104. Sort in a Pivot Chart
  105. Pivot Tables
  106. Create calendar with running monthly/weekly totals and averages
  107. "Unhiding" missing rows in a pivot table.
  108. Pivot tables
  109. need help with formula in pivot table or should i use vba?
  110. Need help with a formula to sum and search for top ten values
  111. Block access to raw data but still allow filtering in a pivot table?
  112. Pivot Table Relationship displaying incorrect Time Value
  113. Pivot table totals
  114. Multiple columns with duplicate data to display as unique numbers in a pivot
  115. Pivot Table Refresh Problem (Data imported from SQL Server)
  116. Issue with PivotTable and imported data through OData
  117. data fill same as chart
  118. Timeline Slicer
  119. Skipping blank Values in Pivot Table. Please help!
  120. PivotTables on Mac
  121. Unable to see quick explore option to drill down
  122. Can't get quick explore to appear
  123. Pivot Table Refresh
  124. Can I get a Result Evaluating a Row Field.
  125. Getting pivot totals to the left
  126. Show products by supplier
  127. Pivot Table - Error message on summarising the Count field into Sum field
  128. Having an issue with my Pivot Table, wondering if someone can help me and show me the
  129. collapse/expand (blank)
  130. pivot table configuration
  131. How to add a % column to pivot table????
  132. Request suggestion for the table
  133. Removing "(blank)" from the pivot table's report filter dropdown list
  134. show value as % of next door columns Total
  135. Join info from 2 Pivot Tables
  136. How to select multiple fields to add to the values section in a pivot table report
  137. Locking down a pivot table
  138. Pivot Table Filter
  139. How to make a CHART from a Pivoted Summary.
  140. PivotTable AutoSort
  141. Getting the counts from multiple filters to use within pivot
  142. Creating a Pivot table showing count by quarterly sales
  143. Protecting/unprotecting sheets at the same time and keeping slice functionality?
  144. Hiding data in a pivot table
  145. please help to make daily report in excel
  146. Remove a field from Slicer
  147. convert day:hour:min (1:3:40) to just hours only or convert into a format transferrab
  148. Pivot table showing results from multiple source columns
  149. Pivot table showing results from multiple source columns
  150. New to Power Pivot -Learning
  151. Timestamp to Pivot table case count
  152. Data not showing in Pivot Table
  153. Creating two pivot tables using same source but different category groupings
  154. PIVOT - column comparison
  155. pivot - manual order at a specific row label (no A-Z / Z-A sorting)!!
  156. How to automatically adapt the print out area of a Pivot Table?
  157. Pivot Filtering by Dates
  158. Grand Total as a new Column
  159. Add custom column to pivot table
  160. Using the Data Model for Distinct Count Summarized Value
  161. Pivot Table Data Ordering
  162. Grouping by two columns - numbers and names
  163. Adding a "tag" to my pivottable
  164. Extracting Data from Pivot Table using VBA?
  165. date format changed in pivot
  166. Auto refresh pivot table
  167. Pivot Table Calculated Field to Assign Scores
  168. External Data Connection
  169. How to calculate subscription Contract value along pivot table time slices?
  170. Pivot Table Report format
  171. Rows between Filters and Pivot Table
  172. Pivot tables and chart colors
  173. Single instance of column item in Pivot table
  174. Change in data source
  175. How to consolidate multiple Pivot tables?
  176. Interconnected Slicers Filtering Issue
  177. count unique values
  178. Error Updating Pivot Table
  179. Calculated Field
  180. Extracting data from Pivot Table to use in a lookup list
  181. Values not the same in Data and Pivot Table
  182. Refreshing specific tables
  183. Spot the differences in Pivot tables
  184. Excel - pivot table does not group dates
  185. Count with pivot tables non numeric
  186. How do I add a comparison column - please refer sheet
  187. Assistance Request: Pivot Table and Charts
  188. Pivot Table and Chart - Specific Row Grouping
  189. Question on preparing excel data for Pivot Table
  190. Pivot table Count by Closed Date
  191. Sort and Hide Row Label
  192. Timeline slicers
  193. Pivot Table reference changing
  194. No Row totals in Pivot table
  195. external data link
  196. Master Sheet with summary of info from tables in other sheets
  197. How do I change Top 10 to filter only 1 year
  198. Pivot-Scorecard Automation
  199. Help with setup of pivot table
  200. Pivot Table complicated split percentages
  201. Timesheet HELP! Pivot table?
  202. Display dropdown list values in Pivot Table
  203. Show percentage based on First value instead of previous
  204. VBA to split single worksheet into multiple files & summarize data with pivot table
  205. Extracting info from Pivot table
  206. Transpose a pivot to a table
  207. Pivot Tables and Shared Files
  208. Would a pivot table help me with this?
  209. Would a pivot table help with this? (Beginner Question)
  210. Tediously adding data to a table year-over-year, looking for pivot ideas..
  211. Pivot Table: Adding the same column from the data model into the pivot column field
  212. Reporting Items in every month they were open, based on creation and closure date.
  213. Pivot chart combined - does not keep
  214. Creating Pivot tables with spreadsheet
  215. Pivot table- Tabs seem to be linked to one another
  216. How to Show Data
  217. Help with Excel Rankings Report using Pivot Table Data
  218. How to show differences between columns in pivot tables
  219. Comparing multiple sets of data
  220. Default cannot drag fields to pivot table
  221. Analysing alot of data using a pivot table
  222. how to Countif with between two date to get pivot table data
  223. Pivot Table external locking external sources in Excel 2016
  224. How to show Percentage in Pivot Table?
  225. How to compare lots of data every year
  226. Power Pivot Table
  227. Pivot tables - custom formats
  228. Slicer error
  229. pivot table results
  230. What does a slicer do?
  231. How to insert blank row(s) when data source updates with new entries?
  232. Allocate data from different data groups
  233. How to calculate Contribution using DAX - Complex Business Problem - Please help
  234. MS Query Vs Powerpivot
  235. I need help with pivot table
  236. multiple pivot tables but common rows and slicers
  237. Keeping Data Alphabetized After Refreshing
  238. Transferring Comments into a Pivot Table
  239. sorting in pivot table without (sub)totals without grouping
  240. Pivot Table Filter
  241. Setting Up Names in a Table as Row Label
  242. Pivot filters lost
  243. can I create slicer connections to filter both pivot and regular tables?
  244. How to remove/hide buttons from PivotChart?
  245. Blank Lines After Filtering Pivot Table
  246. Maintaining Historical Totals in a Pivot Table
  247. Product Life Cycle
  248. Instead of Zero pivot sum option is returning to the value -4.54747350886464E-13
  249. Monthly calculation based on start and finish date
  250. Filling in lines on pivot table