Two or more measures in the same column

Posted by: rickywy2008 on 3 August 2017, 4:02 pm EST

  • Posted 3 August 2017, 4:02 pm EST

    Good Afternoon



    I'm working with Active Analysis ver 2.1.863.0



    I'm using GrapeCity.ActiveAnalysis.Layout.ILayoutActions and everything works fine, but now i have a problem or maybe i dit it something wrong.



    When i use GrapeCity.ActiveAnalysis.Layout.ShelfKind.DataShelf to add two or more measures to my pivot, it shows all Measures in the same column. Looking for a solution I noticed that if I add the attribute called Measure (Medida) to the column section everything works as I need, but I could not do this using GrapeCity.ActiveAnalysis.Layout.ShelfKind.ColumnShelf because indicates that this attribute does not exist in context.



    I apreciate any help.



    Nelson Ricardo Restrepo









  • Replied 3 August 2017, 4:02 pm EST

    In addition to the above you need to add a Measure called Values (Valores) to the label section.



    Regards



    Nelson Ricardo Restrepo



    P. Attached to this message are the picture of how it should be working.

  • Replied 3 August 2017, 4:02 pm EST

    Nelson,

    I would first like you to check this link
    which provides more information on the Intrinsic Fields class. You can
    directly use the two properties exposed by this class to get the
    Measures and Values names (as they are MeasureNames and MeasureValues
    actually) and place them on desired shelf.

    I have attached a small sample application which demonstrates how you can get the desired functionality. Please check the sample and let me know if it helps. Since the samples uses Nwind local cube as the datasource, please update its path before running the sample.

    Regards,
    Sankalp

    2013/04/MultipleMeasures.zip
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels