excel-2013powerview
PowerView automatically aggregating data
I have several fields in a SQL Server Table that are Integer but are labels. When I try to bring the data into PowerView for Excel it automatically aggregates these numbers and gives me an aggregate with a Sigma showing they are a sum.
How do you change this?
I am new to PowerView and this is kind of annoying. I don't want to bring the data in as a table as it is over 1 million rows.
Thanks, Scott
Solution
Power View will automatically aggregate numbers, there are two options to prevent this. In the Power View field well fields can be set to 'do no aggregate', alternatively fields can be prevented by aggregating at all via the Power Pivot window.
Do not summarize via the field well
Do not summarize via Power Pivot
- Automatic numbering in Excel with hierarchy
- Why do I need a space before the '^' operator in VBA for Excel 2013 or it will produce a compile time error "Expected list or separator"
- Separate octets of IP address using formulas
- Create A Chart On Each Worksheet Using The Data From That Worksheet
- First Name & Last Name drop down list
- RANK formula gives incorrect result when values exist more than one
- Formulas Throw Invalid Reference
- Looping through rows in Excel to assign a counter to different rows
- Camel case converter in an excel
- Clear contents and formatting of an Excel cell with a single command
- Always Allow Native DB Queries
- Row Deselection Queries
- VBA: Passing multiple values to Instr
- Power Query Transpose Table
- Remove blank rows from a column
- Need Help in Excel formula - Product wise large to small
- Text in cell repeats or doubles, why?
- In excel, how do i hide duplicate value of Column A & B (where AB=BA)
- Run-Time Errors 380 and 381 generated when searching for a word in a Listbox through a textbox on a Userform
- How to lookup and return multiple values alternating (50/50)
- How can i split a column in more columns based on a specific value in certain cells
- VBA executes slowly if there are blank cells
- Excel ran out of resources while attempting to calculate one or more formulas
- Does not appear power pivot add-in in Excel 2013
- Populate Combobox with font names
- Excel and RabbitMQ - Process RabbitMQ Messages in Excel?
- How to hide rows in an Excel form if they are blank
- Compare Two Worksheets and Highlight Difference
- C++ Office Excel Plugin Range QueryInterface "E_NOINTERFACE" Problem
- Below Code not working on large selection