• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. L

    Referring to timeline values in a formula

    Hi, Thanks for the quick reply Hui. I managed to solve the problem, simply by referring to the "Timeline_DateKey" in the same cubeset code as above. I never even thought of referring to the min/max values in the pivot table, but that would work just as well and with a simpler formula too...
  2. L

    Referring to timeline values in a formula

    Hi, I have a spreadsheet where I used slicers on the year and month (yyyy-mm) that I referred to in my formulas to show a dynamic title saying "Report from Nov-2015 to Sep-2016" etc. If there a way to refer to the minimum and maximum values selected in a timeline in a similar fashion? The...
  3. L

    PowerPivot - add YTD at end of pivot table showing months

    Hi, I am very new to PowerPivot, but have been using Pivot tables for years, so have an understanding of how they work generally. I am trying to create a pivot table (and chart) that after the user has filtered by Quarter the month counts show up with the total YTD at the end. I have...
  4. L

    can I base multiple pivots from one olap connection in excel 2010?

    Thanks SirJB7, I've looked on the forum and on the web generally to find an answer before posting my question, but unfortunately I can't find one! There are a few pages describing the problems with doing multiple pivots but none describing how to do it... perhaps I'm missing something and...
  5. L

    can I base multiple pivots from one olap connection in excel 2010?

    Hi. I have multiple pivot tables in one spreadsheet that are looking at the same view in my sql server database using an olap connection. When I refresh the spreadsheet it takes about 7 minutes to update as each table is pulling the data fresh from the server. Is it possible to link multiple...
Back
Top