[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • Last Modified:

Change the Pivot Calculation option

Hi,

I've developed a CUBE. Users want to build their own calculation on the Excell file as they are doing the Pivoe table when they built using local data.

Please check attached screenshot which describe my requirment.
Thanks for any information about how to enable this.
PivotCalculation-Disable.PNG
0
keplan
Asked:
keplan
  • 7
  • 3
  • 2
8 Solutions
 
Koen Van WielinkIT ConsultantCommented:
Hi Keplan,

As far as I know this is not possible in standard Excel Pivots. You have to stick with the default aggregate options that are available.
Perhaps you should have a look at PowerPivot. This is an add-in available from Excel 2010 onwards. You could load the cube into the PowerPivot add it and use the formula options there to calculate custom formulas which can then be aggregated in a pivot.
More info here:

http://technet.microsoft.com/en-us/library/gg413497.aspx

Kvwielink
0
 
Koen Van WielinkIT ConsultantCommented:
Hi Keplan,

As far as I know this is not possible in standard Excel Pivots. You have to stick with the default aggregate options that are available.
Perhaps you should have a look at PowerPivot. This is an add-in available from Excel 2010 onwards. You could load the cube into the PowerPivot add it and use the formula options there to calculate custom formulas which can then be aggregated in a pivot.
More info here:

http://technet.microsoft.com/en-us/library/gg413497.aspx

Kvwielink
0
 
Koen Van WielinkIT ConsultantCommented:
Hi Keplan,

As far as I know this is not possible in standard Excel Pivots. You have to stick with the default aggregate options that are available.
Perhaps you should have a look at PowerPivot. This is an add-in available from Excel 2010 onwards. You could load the cube into the PowerPivot add it and use the formula options there to calculate custom formulas which can then be aggregated in a pivot.
More info here:

http://technet.microsoft.com/en-us/library/gg413497.aspx

Kvwielink
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Koen Van WielinkIT ConsultantCommented:
Sorry Keplan, just realized I misread your post a bit. When I check my existing Pivots, this option is available using standard ODBC and OLE DB connections. I suspect it might have something to do with the fact you are querying a cube and that Excel might not be able to handle custom aggregates on a cube, but I don't know this for sure as I've never tried it.
PowerPivot still might help you out, we're keen to explore this option in our own company.
0
 
Koen Van WielinkIT ConsultantCommented:
Sorry Keplan, just realized I misread your post a bit. When I check my existing Pivots, this option is available using standard ODBC and OLE DB connections. I suspect it might have something to do with the fact you are querying a cube and that Excel might not be able to handle custom aggregates on a cube, but I don't know this for sure as I've never tried it.
PowerPivot still might help you out, we're keen to explore this option in our own company.
0
 
Koen Van WielinkIT ConsultantCommented:
Sorry Keplan, just realized I misread your post a bit. When I check my existing Pivots, this option is available using standard ODBC and OLE DB connections. I suspect it might have something to do with the fact you are querying a cube and that Excel might not be able to handle custom aggregates on a cube, but I don't know this for sure as I've never tried it.
PowerPivot still might help you out, we're keen to explore this option in our own company.
0
 
PortletPaulCommented:
echo (on, on, on) x 2 - interesting browser you use Kvwielink :0
0
 
Koen Van WielinkIT ConsultantCommented:
Hi Paul, i know! It's driving me nuts! Tried chrome, firefox, IE, all exhibit the same problem, but not consistently. Recently got a new laptop, and the problem persists. Same when on my home or my office network. Don't suppose you have any idea what might be up Paul?
0
 
PortletPaulCommented:
>>Recently got a new laptop, and the problem persists. home or my office network
mmm, same ISP? maybe ask a question? this sounds worse than it used to be
0
 
keplanAuthor Commented:
k
0
 
keplanAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for keplan's comment #a39280115

for the following reason:

h
0
 
keplanAuthor Commented:
ds
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 7
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now