Is there a way to combined and calculate 2 cards in 1?

Taichi
Taichi Member
edited July 2022 in Charting

I want to combine a revenue card in positive numbers and a expense card also in negative numbers to a PL card. is that possible?

each revenue card and expense card shows multiple users that are already sorted in pivot table.

I want to subtract expenses from the revenue per users.

Best Answer

  • mhouston
    mhouston Contributor
    Answer ✓

    You can't combine two cards into one. If you have a revenue dataset and an expense dataset, you can append them and then you can build a card that has both revenue and expenses.

Answers

  • mhouston
    mhouston Contributor
    Answer ✓

    You can't combine two cards into one. If you have a revenue dataset and an expense dataset, you can append them and then you can build a card that has both revenue and expenses.

  • MichelleH
    MichelleH Coach

    @Taichi

    I agree with @mhouston 's suggestion. To add to it, you could use ETL to recreate the respective pivot tables and then append or join them both together.

  • Taichi
    Taichi Member

    @mhouston , @MichelleH

    thank you for your comments. I will try to do so!!

Categories