Hello,
Does anyone know if it is possible to use different aggregation methods in the same pivot table?
I have a datafile with results for different indicators. They need different types of aggregation: SUM, MAX or AVERAGE. In my source data I have made a column that indicates for each record...
Hello,
Is there a way one could build a classification tree in Excel, such as XLMiner could do (but is very costly software).
See e.g. this excel file: http://mande.co.uk/blog/wp-content/uploads/2012/04/epm-data-only.xlsx
and this type of classification tree...
Dear Hui,
This is really great. Yes, it does the trick I needed.
I'm not sure if I'm feint at heart, but I don't get exactly what the formula's do. This looks like what I've seen in your chart 'my excel age' and I remember not fully understanding that one as well.
I will be able to use this...
records are being added over time (e.g. new partner, new indicator) but not so frequent.
and over time data for new columns is added (plan 2012, realised 2012 etc).
Thanks Hui, the first example is helpful. However, it always selects a single value. What I would need is sliders or control boxes that form a name, and the name defines a subset of the data: always more than one row, but it depends how many rows.
E.g. 3 'output' type of data that I would like...
hello,
I have worked with named ranges linked to a form control and a graph. To do that, I had to sort the data and applied names to each group or rows in the data table. Using the form control selected to name=range of data to be used.
Does anyone know how I could do that if I want to...
Does anybody know a method to link a filter to a cell, or to a form control? The filter are too complicated to use for the users I am working for.
Wouter