I want to calculate the percentage difference between Qtrs in Pivot table

Options
gokul
gokul Member
in Beast Mode
image.png

it's like I want a col where I need to calculate the difference between Q1 and Q2 percentages

Best Answer

  • Manasi_Panov
    Manasi_Panov Coach
    Answer ✓

    Hi @gokul,

    Could you please share the formula you are using for "% for col total"? In general, you can use CASE logic like:

    (CASE WHEN QUARTER(Date) = 2 THEN "% for col total"
    ELSE 0
    END) - (CASE WHEN QUARTER(Date) = 1 THEN "% for col total"
    ELSE 0 END)

    If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.

Answers

  • Manasi_Panov
    Manasi_Panov Coach
    Answer ✓

    Hi @gokul,

    Could you please share the formula you are using for "% for col total"? In general, you can use CASE logic like:

    (CASE WHEN QUARTER(Date) = 2 THEN "% for col total"
    ELSE 0
    END) - (CASE WHEN QUARTER(Date) = 1 THEN "% for col total"
    ELSE 0 END)

    If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.

Categories