19 Replies Latest reply: Jun 29, 2018 4:45 AM by Ugur Arslan RSS

    3 Count questions for financial purposes

    Ugur Arslan

      Dear all,

       

      I need the answer for the following three questions:

       

      First Question:
      How many Seller ID's do have AR?
      Answer: 12
      Expression:
      Second Question
      How many Seller ID's  with an AR suspended?
      Answer: 7
      Expression:
      Third Question
      How many Seller ID's with an AR 90+ are not suspended?
      Answer = 3 account

       

      I have the following dimensions:

       

      Aging buckets
      Current
      1-30 days
      31-60 days
      61-90 days
      91-120 days
      121-150 days
      150-181 days
      181+ days

       

      Suspend Indicator
      Suspended
      Not Suspended

       

      Seller ID
      1
      4
      7
      90
      660
      3456
      5677
      89877
      321234
      445444
      456778
      7883983
      8498989
      44929029

       

      and the following measurement:

       

      AR amt USD

      with all different AR amounts

       

      I created the following pivot

       

      Pivot Table
      Collumn=[Seller ID]
      =[Suspend Indicator]
      Row=[Aging Buckets]
      Measurement=sum([AR amt USD])

       

      Result of the pivot=

       

      Seller IDSuspend IndicatorCurrent1-30 days31-60 days61-90 days91-120 days121-150 days150-181 days181+ days
      1Suspended$5.00$67.00$67.00$-  $7.00$74.00$734.00$- 
      4Not Suspended$66.00$7.00$-  $7.00$8.00$-  $-  $73.00
      7Suspended$7.00$78.00$8.00$-  $-  $-  $-  $- 
      90Not Suspended$-  $-  $-  $-  $-  $-  $-  $- 
      660Not Suspended$7.00$-  $6.00$3.00$3.00$67.00$7.00$- 
      3456Suspended$-  $8.00$-  $-  $-  $4.00$3.00$7.00
      5677Not Suspended$7.00$8.00$7.00$-  $-  $-  $-  $- 
      89877Suspended$8.00$-  $-  $7.00$7.00$-  $-  $3.00
      321234Not Suspended$-  $-  $-  $-  $-  $-  $-  $- 
      445444Suspended$888.00$-  $-  $8.00$8.00$-  $3.00$- 
      456778Not Suspended$-  $-  $5.00$-  $-  $7.00$7.00$- 
      7883983Suspended$87.00$-  $-  $45.00$8.00$-  $3.00$7.00
      8498989Not Suspended$-  $85.00$-  $-  $-  $-  $-  $- 
      44929029Suspended$54.00$-  $5.00$-  $4.00$-  $-  $7.00

       

      Thanks for helping me out... I just couldn't manage it.

       

      Ugur