Skip to Content
avatar image
Former Member

How to get the Group field value in summary field of cross tab

I have a cross tab for Sub Total report after execution the Summary field provide the Merged row with sub total values i want to get the Grouped Value along with "Total" as Label of the Summary field.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 05, 2017 at 07:44 AM

    Hi Pramod,

    I'm not sure I understand this.

    Could you attach a screenshot please?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 06, 2017 at 02:16 AM

    Hi Abhilash,

    Actual Sub Total Report in Cross Tab

    actual-sub-total.jpg

    Required Out Put report

    required-out-put.jpg

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 06, 2017 at 07:18 AM

    You can use formula like max(cost centre)+"Total".

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 18, 2017 at 02:04 AM

    Hi Avijit do have use the Formula directly in the Summary Field or do i have to format the Summary field and then add the formula.Sorry i'm very new to this subject.

    Add comment
    10|10000 characters needed characters exceeded