Share
Report
2,129Content migrated from TechNet. Post attribution to: PK Hong
Hi
I posted a question on how to create graph based on GroupBy function but at the end, there is no any help from PG or others. Finally, I refer to the sample apps and realize that using Width - (Filled with color) will eventually works as of Bar Graph.
Sharing here as an alternative to graph.
1. OnVisible: you may have ClearCollect(BrandbyQty, GroupBy(TableSalesReport, "Brand_Name", "Sales"))
2. Text (box) for the % Bar: Text(Value(Sum(ThisItem.Sales, Qty_Sold)/Sum(TableSalesReport, Qty_Sold))*100, " ##.## %")
3. Width for overlapping bar: 270*Value(Sum(ThisItem.Sales, Qty_Sold)/Sum(TableSalesReport, Qty_Sold))
NB: 270 is the width of Text Box (No. 2)...etc.
Hopefully, PG will have better idea for me or us.
TQ
All responses (
Answers (
