Forum Discussion

netanel's avatar
netanel
Post Prodigy
4 years ago

P&L Help +- & Sort

Hi community, Two questions I'm having trouble with I have a financial statement the Description in the table come from an Dim account The amount comes from the FACT table Everything is connected...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

Please update your sample file with the account reference.

netanel's avatar
netanel
Post Prodigy
4 years ago

 

updated

+ column Agg(+,-) in Dim Account

Thanks

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    fact table is still empty

     

     

    • netanel's avatar
      netanel
      Post Prodigy
      4 years ago

      Sori,
      updated

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago

        Please provide sanitized sample data that fully covers your issue.
        Please show the expected outcome based on the sample data you provided.

         

        Unfortunately your sample data is still not in a usable shape.

         

        You also seem to expect to be able to use data from different levels of the hierarchy.  While that is possible it will make the measure very complex as you will have to account for all hierarchy level scenarios separately to avoid double counting. You may want to rethink that process.