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...
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...
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...
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...
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...