Forum Discussion
Multi Table Excel spreadsheet - is it possible?
Have you tried the option to switch to show measures on rows?
Pat
Thanks again for your reply ppm1
I tried out the switch to show measures on rows, but it wasn't what we were looking for.
To describe it differently, for each given operating unit & project within that operating unit, we would also like to display columns for their address/city/state/zip. Placing them on the right side of the matrix doesn't seem right as we don't really want the first item, or summarized values. We're looking for all the unique items to be shown. But placing them on the left as rows, makes them appear as deeper branches of a tree. We really only want the address/city/state/zip to appear as a single, multi column branch in the tree.
I guess the closest I can think would be to create a new column comprising all the values in the address/city/state/zip columns & use that within the matrix, but we would also like to be able to export those values into an excel spreadsheet as separate columns...
Does that make sense?
Thanks again ppm1 !
OK, probably the easiest representation of the data we need after export to Excel, would be the following image:
(If you could imagine the blank cells on the left of the black square filled with non numeric data, and the blank cells on the right of the black square filled with numeric data.)
I am also envisaging the black square as the separator also in the matrix.
The main difficulty as I see it, is that I would like to include all the fields on the left of the black square as a single row (i.e. in the matrix visual, to be able to expand it at a single click, rather than each column being represented as a deeper branch of a tree).
The other difficulty is that I would like to include a percentage (CO-OP Cost %) in the data on the right of the black square. Being a percentage, this can neither be summed nor averaged, so I'm guessing I would need to exclude it from the matrix (?)
It sounds like you are describing a table visual. All values would be shown on the same row for all combinations. If you needed the black column, you could probably do a constant measure and use conditional formatting to alway make it black.
Pat