Hello everyone!
Pivots are great to use, but how do you "return" the text fields associated with the line?
In some cases my data is text, in the case of the example uploaded, its the "land use" for the development brief, or alternatively it could be a notes column, in other cases its a number.
My workaround for returning the number is a Max (or min) however i am yet to figure out an elegant solution for the text. In my example I have shown a vlookup, but you can see that it gets messy when the table changes size. And this is likely to be the case since i love the use of slicers to filter the data.
I would appreciate your collective suggestion on how best to present this information, is the pivot is not the right tool, or is there another way of doing this?
I am using MS Excel 2013.
Your help is appreciated in advance!
Pivots are great to use, but how do you "return" the text fields associated with the line?
In some cases my data is text, in the case of the example uploaded, its the "land use" for the development brief, or alternatively it could be a notes column, in other cases its a number.
My workaround for returning the number is a Max (or min) however i am yet to figure out an elegant solution for the text. In my example I have shown a vlookup, but you can see that it gets messy when the table changes size. And this is likely to be the case since i love the use of slicers to filter the data.
I would appreciate your collective suggestion on how best to present this information, is the pivot is not the right tool, or is there another way of doing this?
I am using MS Excel 2013.
Your help is appreciated in advance!