Forum Discussion
Entering chart titles for chrats created using pivot tables.
- May 09, 2017
HI Aditya,
Sorry, i didn't catch how you structure your data (merged columns in main table, is one ID = one Title or not, why not separate table if so, etc) and why do we spaeak about two slicer = i found only one slicer fo ID here.
Anyway, back to titling - there are two main approach to pickup slicer value. Use cube formulas and use helper pivot table. More details for example here http://chandoo.org/wp/2015/06/24/introduction-to-slicers/
Since you don't load your pivot to data model, we may use helper pivot.
In attached file i added one more pivot table with value of min dates (my guess your dates are linked to ID:s, but you may use any other vakue here);
linked your ID slicer to that table through slicer connections;
formatted value in new pivot table;
linked chart title to first row of new pivot table as link in previous table
That's just sample, you may add checking if more than one row selected, if nothing is selected, if you have more connected slicers.
The idea is this helper pivot table returns exactly the values selected in slicers (not but slicers).
VBA or Powershell that doesn't matter, depends mainly on your usage scenarios. In any case some coding.
Hey Sergei,
Have been looking for some option taking some help form people for writing the code because that is the only option to do that.
Aditya
- Aditya JadhavMay 15, 2017Brass Contributor
Hi Sergei,
I totally understand that hence i'm not asking for the code help. Just trying to figure out the way ,have already started working on it manually because of this issue, i'm really not sure how much time it will take to first learn the codes and then apply them so have done it manually and still doing it.
Regards,
Aditya
- SergeiBaklanMay 13, 2017Diamond Contributor
Hi Aditya,
In our corporate environment we don't share macro-enabled files, thus i practically don't work with scripts and can't help here.