Team,
I am trying to realign the header in desired format but i could not, Formula follows,
Test1.Run(User().Email,
JSON(With(
{TheTable:
ShowColumns(
AddColumns(
GroupBy(
Filter(
ShowColumns(
Dailyinventory, "crf99_sno", "crf99_materialdesc",
"crf99_materialno", "createdon",
"crf99_bbd", "crf99_qty"
),
DateDiff(createdon,Today(),Days) = 0
), "crf99_materialdesc", "NewGroup"
),
"Materialno",
First(NewGroup).crf99_materialno,
"Qty",
Sum(NewGroup, crf99_qty),
"Created On",
Last(NewGroup).createdon,
"bbd",
Last(NewGroup).crf99_bbd,
"Sap-Stock",
LookUp(
sapstock,
material = First(NewGroup).crf99_materialno,
unrestrictedStock
)
),
"Materialno",
"crf99_materialdesc",
"Qty",
"Sap-Stock",
"Created On",
"bbd"
)
},
ForAll(Sequence(CountRows(TheTable)), Patch(Last(FirstN(TheTable, Value)),{Sno : Value}))
)
)
)
Current result,
Expected
Can you help me with expected format
