No announcements
Found 2444993 threads
-
2 VotesPowerPivot-View with column which is displayed as last column
Hi I've an PowerPivot-Table in Excel with ProductGroups as rows, Month as Columns and Turnover as Values(SUM).Answered | 1 Replies | 1050 Views | Created by chmav - Wednesday, January 21, 2015 9:14 PM | Last reply by recio - Thursday, January 22, 2015 4:33 PM
-
4 Votes
Number of columns in PowerPivot
Moreover, the better solution would be to write some customizeded SQL views on NAV database to define some logic and structure before bringing data to PowerPivot model.Answered | 3 Replies | 2070 Views | Created by gpelit - Thursday, December 4, 2014 3:32 PM | Last reply by YNGUYEN01 - Monday, December 8, 2014 11:18 AM -
0 Votes
New column on sql view is not being pulled into powerpivot model
Typically, PowerPivot will pick up the new column, but will add it as a new column on the end (far right in the data view).Answered | 1 Replies | 3555 Views | Created by Idanco - Friday, December 21, 2012 9:41 AM | Last reply by Brent Greenwood - Friday, December 21, 2012 4:17 PM -
0 Votes
SSRS column chart: last column is not displayed properly.
First of all, if you need the top 5 departments, what you can do is to got to the X axis group or the category (which is the Client Department here) and set a filter on the top 5.Answered | 3 Replies | 4626 Views | Created by Samulye - Tuesday, November 27, 2012 3:11 PM | Last reply by Samulye - Thursday, November 29, 2012 10:04 AM -
2 Votes
How to add up a PowerPivot Column
Normally, a simple total can be achieved with Measure = Sum(Column) nothing special.Answered | 2 Replies | 2882 Views | Created by pentagaldad - Friday, August 30, 2013 3:22 PM | Last reply by Olaf Helper - Friday, August 30, 2013 3:45 PM -
1 Votes
Calculated Column in PowerPivot
For more information, please refer to below ...Answered | 4 Replies | 893 Views | Created by Asimsidd - Tuesday, July 25, 2017 1:37 PM | Last reply by willson yuan - Thursday, July 27, 2017 2:40 AM -
0 Votes
Lost columns during the transfer from excel to powerpivot
Hi Sanne, According to your description, some columns are missing after imported data from excel to PowerPivot data model, right?Answered | 1 Replies | 1023 Views | Created by Sanne91 - Tuesday, September 8, 2015 11:54 AM | Last reply by Charlie Liao - Wednesday, September 9, 2015 1:41 AM -
1 Votes
Powerpivot Grand Total doen't reflects the values displayed in the column
If not, are you able to provide us with some test data, a description of the relationships between the tables (i.e. columns A from Table 1 links has a lookup ...Answered | 2 Replies | 1671 Views | Created by Marco01 - Friday, January 3, 2014 4:04 PM | Last reply by Ed Price - MSFT - Friday, January 17, 2014 8:24 PM -
1 Votes
How to display 'Last Updated by' or 'Last Posted By' column in SharePoint Discussion List View List?
Hi Jun, Last Updated column is used to record the time of last post to a the thread, so the last updated by equals to the last posted ...Answered | 7 Replies | 9671 Views | Created by James8146325 - Monday, December 3, 2012 8:43 AM | Last reply by Kelly Chen 2012 - Wednesday, December 5, 2012 7:21 AM -
4 Votes
Are calculated columns compressed in a PowerPivot model?
Note that the complexity here must be considered from a DAX point of view - what may seem simple at first glance can actually be very inefficient when implemented in the Tabular ...Answered | 5 Replies | 861 Views | Created by Ben_m1 - Tuesday, October 14, 2014 8:19 AM | Last reply by greggyb - Thursday, October 16, 2014 3:12 PM -
0 Votes
Last Name Column displays as Title Column in Contacts List
If you follow Jack's instruction, you'll notice all the Title column of all lists in the site collection will be changed to Last Name.Answered | 6 Replies | 4510 Views | Created by namshan - Friday, February 15, 2013 5:35 AM | Last reply by Al Gammons - Wednesday, March 9, 2016 6:13 PM -
0 Votes
Drop et recreate column in powerpivot table
Table Properties and uncheck any table you want to drop.Answered | 1 Replies | 3436 Views | Created by ccote - Tuesday, September 25, 2012 5:07 PM | Last reply by Chu Xu - Wednesday, September 26, 2012 1:16 AM -
0 Votes
Clients adding or hiding columns of data on PowerPivot and Sharepoint
the Powerpivot gallery (even in PowerPivot 2012) won't let you modify the pivot table using the browser.Answered | 1 Replies | 3803 Views | Created by Wilbert Ryan - Friday, August 3, 2012 3:01 AM | Last reply by Javier Guillen - Friday, August 3, 2012 2:02 PM -
0 Votes
Specify which columns to display in datagridview
Programmatically, you can set the DataGridViewColumn.Visible property to false How to: Hide Columns in the Windows Forms DataGridView ...Answered | 3 Replies | 843 Views | Created by J Vallee - Monday, January 20, 2020 2:53 PM | Last reply by J Vallee - Monday, January 20, 2020 7:09 PM -
1 Votes
PowerPivot turns columns with blanks into strings instead of numbers
PowerPivot should not turn blanks into strings, but if you have a cell with a space or other whitespace in it the whole column will get treated as a string column.Answered | 1 Replies | 1587 Views | Created by BrainE - Wednesday, July 13, 2016 7:37 PM | Last reply by Darren Gosbell - Monday, July 18, 2016 3:24 AM -
0 Votes
PowerPivot caltulation between rows and columns
Thanks for posting the data, else it would have been very difficult to come up with a suggestion :) Ok, from what I understand, the order of the rows are based on thee Order ...Answered | 4 Replies | 3483 Views | Created by Kmet Kooperant - Tuesday, October 23, 2012 1:58 PM | Last reply by Kmet Kooperant - Thursday, October 25, 2012 9:30 AM -
3 Votes
PowerPivot for Excel 2013 - Losing formatting with Hierarchy on Columns
I have defined the formatting in the PowerPivot measure grid.Answered | 4 Replies | 1767 Views | Created by Iman_Jabor - Friday, July 18, 2014 2:28 PM | Last reply by sgarciad - Friday, October 21, 2016 7:07 AM -
5 Votes
Way to hide "All" Level of a PowerPivot column in Pivottable?
By changing your aggregate from AggregatedValue:=sum([Value]) To something ...Answered | 3 Replies | 1402 Views | Created by Karaoan - Tuesday, January 14, 2014 11:25 PM | Last reply by MichaelAdrianJohnson - Wednesday, January 15, 2014 11:59 AM -
2 Votes
PowerPivot empty OData feed, no column definitions
Related issue here: http://stackoverflow.com/questions/36151618/specify-columns-in-empty-iqueryable-in-wcf-data-service is that the same underlying problem?Answered | 3 Replies | 1658 Views | Created by Paul Hatcher - Wednesday, November 26, 2014 10:52 AM | Last reply by Daniel Latikaynen - Friday, September 2, 2016 4:41 PM -
1 Votes
PowerPivot Excel 2013 crashes after column rename in source datatabase
Rename the column in the source table/view 2.Answered | 7 Replies | 2221 Views | Created by Arjan Fraaij - Tuesday, June 10, 2014 12:42 PM | Last reply by Michael Amadi - Monday, June 23, 2014 3:22 PM - Items 1 to 20 of 2444993 Next ›
No announcements
