Pivot table and showing results from table

Hi Guys,

i have a table like here:

Screenshot_199.png

and now i would like to show which post (ID) is the most effective (number of likes), so show if posts with video or maybe with picture or just text alone have more likes.

How can i do a report? How i could show the results in pivot table ? It is possible when source data is like this? Maybe i should transfor it first?

Thanks for any tips,
Best,
Jacek

I really think you need to show manually what you would like the solution to look like, I am finding it hard to visualise the answer, do you just want the line with the highest likes returned?

thank you davsth,

i do not know ho to do this manually - this is teoretically how i can show report for end user to have value from it?
So how can you prepare report where user will know that post with only text are the most viewed for example.

Or you will get result that video is the best for you. Looking on this input table it is hard to read that...

Best,
Jacek

hi Rory,

thank you.

i got solution here:
https://www.excelforum.com/excel-for...ml#post5554352

Best,
Jacek