topic Re: Create a report in required format in App Development

Create a report in required format

rob_vander — Thu, 01 Jun 2023 23:08:31 GMT

Hi All,

I have below data. I

I want to create a report in below format.

Kushal_Chawda — Fri, 02 Jun 2023 10:28:20 GMT

@rob_vander try below. Create a table with below dimension and measure

1) Add Dimension ID with below text colour expression

=if(ID=Above(total ID,1),white())

2) Total Sites : Add Measure with expression and text colour expression

=Sum(total <ID>[Number of sites]) text colour expression =if(ID=Above(total ID,1),white())

3) Add Dimension Option with below text colour expression

=if(Option=Above(total Option,1),white())

4) Total Option Sites : Add Measure with expression and text colour expression

Sum(total <ID, Option>[Number of sites]) text colour expression =if(Option=Above(total Option,1),white())

5) Add dimension Value

6) Total Value Sites: Add measure with below expression

Sum([Number of sites])

rob_vander — Fri, 02 Jun 2023 11:43:20 GMT