SUMMARIZE WITH STATIC COLUMN and REORDER

[datobi]

Hi

I am trying to create a table (later will be used with a union for sankey diagram) with SUMMARIZE with a static column.

my table = SUMMARIZE(FILTER(pmt, pmt[Method Of Payment] = "AMOP" && pmt[Transaction Type] = "Authorization" && pmt[Step] = "Validation"),"CUSTOM NAME", "FIX VALUE", pmt[Step], "count", COUNT(pmt[PRI]))

where I want to add a column "CUSTOM NAME" with a fix value"FIX VALUE", I am unable to do so.

I can only add it after the COUNT(pmt[PRI]).

How can I add it the way I want, or I do I reorder it after doing a summarize

[datobi]

Thanks, I am just over complicating things when there is just a simple solution

[Greg_Deckler]

@datobi No worries, sometimes just takes another set of eyes.

[Greg_Deckler · Accepted solution]

@datobi Maybe:

my table = 
  SUMMARIZE(
    FILTER(pmt, pmt[Method Of Payment] = "AMOP" && pmt[Transaction Type] = "Authorization" && pmt[Step] = "Validation"),
    pmt[Step], 
    "CUSTOM NAME", "FIX VALUE", 
    "count", COUNT(pmt[PRI])
  )