Tableau - Create new table with custom text values E.g. Min, Max, Median, Average etc

Question

Hi All,

I need to create table #2 (in the snapshot) based on table 1 (input) values that exist in my database. I am not sure how to create the custom fields with values Min, Max, Average, and Median. So I can at least write nested if else. I've tried paramter list but it shows max value at a time

Answer 1

Look at Fixed LOD calculations.

{FIXED [Quarter] : MAX([P1]) }

Then replace MAX with the other measures you need.