1. TARGIT Community
  2. Community
  3. Frontend, Designer and Consumer

Calculations Including Two Dimensions and Multiple Measures

Avatar
Elliott Kleckner

We wanted to create a calculation of specific data points in a crosstab that had two dimensions and four measures. Is there a way to pick individual cells in the crosstab to add to a calculation? We are trying to add specific pieces of data in the crosstab together, not all.

Thank you!

0

Comments

4 comments
Sort by Date Votes
  • Avatar
    Ole Dyring

    Hi Elliot,

    I am pretty sure I will be able to help you here.

    However, please provide a screenshot of the crosstab so that I can better answer your question.

    BR / Ole

    1
  • Avatar
    Elliott Kleckner

    Good morning, 

    Please see the below images.

    0
  • Avatar
    Ole Dyring

    Thank you Elliot,

    So, Departments can be either "Parts" or "Service". Service Invoice Types can be either "Parts" or "Service" or "Other Charges". Furthermore, you have the three measures.

    If you insert a calculation as a new calculated column, you can use these references:

    • K column: sum(@"[Parts]";"[Parts]", 0, m1)
    • L column: sum(@"[Parts]";"[Parts]", 0, m2)
    • M column: sum(@"[Parts]";"[Parts]", 0, m3)
    • N column: sum(@"[Parts]";"[Service]", 0, m1)
    • O column: sum(@"[Parts]";"[Service]", 0, m2)
    • P column: sum(@"[Parts]";"[Service]", 0, m3)
    • Q column: sum(@"[Parts]";"[Other Charges]", 0, m1)
    • R column: sum(@"[Parts]";"[Other Charges]", 0, m2)
    • S column: sum(@"[Parts]";"[Other Charges]", 0, m3)
    • T column: sum(@"[Service]";"[Parts]", 0, m1)
    • U column: sum(@"[Service]";"[Parts]", 0, m2)
    • V column: sum(@"[Service]";"[Parts]", 0, m3)

    BR / Ole

    1
  • Avatar
    Elliott Kleckner

    Looks like that worked perfectly!

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post