power pivot 2013

Hello, Apologies if this is in another thread, I did a search on control chart on the threads with no luck. I am trying to create a pivot table that will provide me with a control chart I am looking at having a data model with calculated fields named "Control Line", "UCL", "LCL" and "Std...

i am using Microsoft office 2013. and unable to find power pivot tab in excel. this tab is also not available in COM add-ins. then what can i do? from where can I do the same.

Hi, I'm having a problem with a (power) pivot table. It automatically adds this all group to all my filters. When I click on all and expand it I get the actually set of filters I want. Only these also have the expand sign (+) next to them but there is nothing underneath. When I click on the...

I have a bit of script that I need some assistance with. The purpose of the script is to iterate over a Power Pivot table and for each item in the pivot, filter and export to a new file. However when I get to the line: 'pf.CurrentPage = pi.Value pf.CurrentPageName = pi.Value With...

I've been a long-time Excel user (25 years) and this one has me stumped. I think I've been staring at it too long or something, but I'll be darned if I can find a way to make it work. I've created a simplified simulation of my data, which consists of the following tables and columns: Revenue...

Hello, & thank you for any help you may offer! I tried to search the forum but could not find an answer to my issue. I have a powerpivot table from my data model with 6 columns, & (currently) 2 filters (wanting to add a 3rd but need to figure out the relationships- different issue). 3 of the...

Need to add a column in above pivot which shows [Dezired RAG] only on PCE Total values(for e.g. FostexxxxxxxxxxTotal) : Note: I am using Excel 2013 power pivot. No Power Query. RAG Table: >90 days then "R",>30 days then "A" Note: I have used: RAG Measure:=IF(MAX([Max DPD])>90,"R",IF(MAX([Max...

Need to add a column in above pivot which shows [Dezired result] the count of [Credit Family Names] whose [Sum of Sum of Primary used USD] is equal to Zero or Blank: Note: I am using Excel 2013 power pivot. No Power Query. <colgroup><col><col></colgroup><tbody>...