Accounting Card

Winnie_1234

Hi, is there any table format card that is ready to use in domo suitable for displaying P&L accounting? it's a huge dataset and i need to aggregate them by month in a table. The dataset contains also different years, types and locations to be used as filters/variables.

Plus, I am required to create and add hierarchical metric rows. For example, Margin V1, V2, V3 are not originally available in my dataset. I need to hierarchically calculate them using the available metrics such as Sales-Cost=Margin V1, then Margin V1+Related Goods Sales-Related Cost=Margin V2. Margin V2+Discount=Margin V3. They will be added as the new calculation rows.

Please help

, appreciate it very much.