Hi @amsrivas ,
Actually I do not quite understand your demand....
Could you show me your original data in excel?
I need to know what the original table looks like and what the result table looks like.
I assume that in excel, your table looks like this: (table1)
| Name |
Price |
| A1 |
100 |
| B1 |
15 |
| B2 |
5 |
You want to display table like this in powerapps: (table2)
//sum for As and Bs
If so, you could transfer table1 to table2 like this:
RenameColumns(
ShowColumns(
AddColumns(
GroupBy(
AddColumns(exceltable,"Name1",Left(Name,1)&"+"),
//add a column with value: A+,B+
"Name1",
"prices"
),
//group based on A+,B+
"sum",
Sum(prices,Price)
),
//add a column with sum of As,Bs
"Name1","sum"),
"Name1","Name",
"sum","Price"
)
Best regards,
