Modify a grid when copying to Excel RRS feed

  • Question

  • Hi

    I have an issue that I don't know if it solvable but maybe somebody has an answer. When I prepare a view in Proclarity I use products in rows and months in columns and sales Q in background to display.

    For rows I use products at different level in hierarchy - for example:

    Category 1

    Product 1 in Category 1

    Product 2 in Category 1


    So basically I want to se data for whole category and separate products within. But this is not problematic. What is problematic is that if I copy it to Excel I get everything flattened in one column in excel but I would like to keep the hierarchy - so each level in separate column - something like that:

    Category 1      Category 1

    Category 1      Product 1

    Category 1      Product 2

    Category 2      Category 2

    Category 2      Product 1


    Is that possible?

    Thank you!



    Wednesday, August 29, 2012 7:10 AM