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

Calculations Including Two Dimensions and Multiple Measures

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 DateVotes
  • 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
  • Elliott Kleckner

    Good morning, 

    Please see the below images.

    0
  • 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
  • Elliott Kleckner

    Looks like that worked perfectly!

    0
Please sign in to leave a comment.