יום חמישי, דצמבר 27, 2012
Those of you who looked for pie chart in PowerPivot and could not find it, can fild it now. To use it, you should install SharePoint 2010 SP1 and Sql Server 2012 SP1. The steps for appropriate installation can be found here : http://msdn.microsoft.com/en-us/library/hh231687
יום ראשון, נובמבר 20, 2011
The default file size of PowerPivot file is 200M. you can change it in the trusted file location: For that, you need to login to the central administration site-> Excel Services Application->Edit Trusted File Location. change the the maximum file size to 2000 –> 2G.
Problem: when playing with PowerPivot and adding ∑Values you get the prefix Sum(…) before the value. Solution: 1.Click on the dropdown combo on the right hand. 2. Click on Edit Measure. 3.Copy the Formula in the “Measure will use this formula” … 4.Click on the New Measure icon in the Power Pivot Ribbon 5.paste the formula to the measure settings and change the measure name. 6. That’s it. now you have a new calculated member with your own...