Stack Overflow
Stack Overflow

Questions tagged [excel-pivot]

48 questions
0
votes
3 answers

In excel pivotal table count unique values

An Excel table contains information when a component of a service is down. So service [column A] (MyService) has a number of components [column B] (component-1, component-2, component-3). Each row means that a component was down for say 5 minutes…
tm1701
  • 7,307
  • 17
  • 79
  • 168
0
votes
1 answer

Where can I find Pivot table option tab in google sheets

I am using Google sheets for learning Pivot table and cannot find the tab PivotTable Options. Any help will be greatly appreciated.
Rima
  • 1,447
  • 1
  • 6
  • 12
0
votes
0 answers

How do I combine Excel pivot table Rows?

Say I have a basic table of data with 1 question asked twice (once before, once after to compare responses). Question 1: Before Question 1: After WRONG CORRECT CORRECT CORRECT WRONG CORRECT I do a pivot table on this data and i…
jkstallard
  • 375
  • 1
  • 2
  • 17
0
votes
0 answers

How do I get data from an unused Pivot Table text field using VBA?

I have a PivotTable which helps us review company charging, and I'm trying to figure out how to display comments the employee left in their time charging in a cell on the sheet. The pivot table itself has rows of Projects and Employee Names, and…
John Hamilton
  • 3
  • 3
0
votes
0 answers

In Excel Pivot, Getting Blank applying "% Difference From" Rather than 100%

I have a below datasheet of Employees I am trying to add PivotTable on the basis of above datasheet We have added Distinct Count of EmpNo and For Variation, we have used Summarize value by Distinct Count of EmpNo and Show Values as "Difference…
Nachiket
  • 511
  • 5
  • 13
0
votes
1 answer

XLookup on Pivot Table using pivot column headers/names instead of worksheet column letters

I am using xLookup to pull some data out of a pivot table. Currently my formulas look like this: =XLOOKUP($A2,'RecT'!$A$5:$A$30,'RecT'!$C$5:$C$30,0) But in my pivot table, column A is called Grade and Column C is called Confirmed. It would be much…
Adam
  • 840
  • 6
  • 24
0
votes
1 answer

Excel not sorting numbers correctly on pivot table

It's as the title says, my excel pivot table is not sorting numbers corretly. When I create the pivot table from my dataset, the goal is to have the data sorted by year, week number, and the Keys sorted by the PM_Value (decreasing order) as shown…
Lucas
  • 53
  • 2
  • 9
0
votes
0 answers

Pivot table in excel contain duplicate data (not sure if it MS Excel Bug)

In Excel, I'm getting duplicate values one with a check and one with unchecked when I create a pivot table.(see the attached excel screen) Please help me with this.
satish mhatre
  • 1
  • 1
0
votes
1 answer

Unexpected Excel Pivot behaviour with SQL Server Tabular model (v2)

We use Excel from Office 365 with a SQL Server 2019 Tabular model I have a "strange" behaviour of Excel Pivot regarding the level at which calculations are requested from DAX. I create 3 simple (SQL Server) tables, MyDim, DimColour and MyFact There…
Eric Mamet
  • 2,681
  • 2
  • 13
  • 43
0
votes
0 answers

Unexpected Excel Pivot behaviour with SQL Server Tabular model

We use Excel from Office 365 with a SQL Server 2019 Tabular model I have a "strange" behaviour of Excel Pivot regarding the level at which calculations are requested from DAX. We have a measure that behaves differently depending on the granularity…
Eric Mamet
  • 2,681
  • 2
  • 13
  • 43
0
votes
1 answer

Error When Trying to Filter Pivot Table With Between Dates Using vb.net

I'm automating a number of reports using a vb.net winforms application. I have one report where I need to update the filter on a Date Field to between 2 dates (Monday & Sunday or the week in question). I'm getting the dates by having the user select…
jbmb2000
  • 61
  • 9
0
votes
0 answers

Simply count values using Pivot Tables in Excel

Sorry to have maybe simple question, but I just learning pivot tables and some advanced functions in the Excel. Let's imagine we having a table with Movies and Votes followed by User1 and User2 and their votes. Please see below table. User1's votes:…
Szymon
  • 633
  • 1
  • 8
  • 28
0
votes
1 answer

Pivot measure based on the pivot row label grouping

There is a table as shown in the pic Is there a way to add a measure to the pivot created from the above data such that different error percentages can be used to different row label groups as shown in the pic? If required I'm ready to do little bit…
sai krishna
  • 21
  • 6
0
votes
2 answers

How to filter one column in Excel Pivot table

I am trying to create a tunnel chart using data from Pivot table. However, I can't find a way to set a condition for one column ("Response Received Column). I want the table to count 5 people, and show 3 people responded. If I do the regular filter,…
ghostabx
  • 43
  • 6
0
votes
0 answers

Excel Pivot Table - Multiple headers with subheaders

Is it possible to create a pivot table with multiple headers, and each header has multiple subheaders? I've been trying to figure out but couldn't find a way on how to do it right. This is my current table (raw data) This is what I want to see in…
bigbryan
  • 411
  • 6
  • 19
  • 36
1
2
3 4