topic Re: Dimension and Expression Pivot table issue in App Development

Dimension and Expression Pivot table issue

Nagaraj6 — Fri, 15 Nov 2024 21:51:02 GMT

Hello All,

I need a help,

I got this output below:

I need expected out below:

MTD Achieved means total lead count, I am getting indiviual count ex:Direct ,Organic,Paid ,Email+Ma,Refferal.I want total count.

FTM Treand means =MTD achieved /(End date-start date)

I have solved upto MTD Achieved.How can I Solve this.

I am try to solving with Dimension and Expression in Pivot table.

Dimesion:

=Pick(Product_types_f,Date,'Exp1'),

Expression:

=Pick(Product_types_f ,
Date,
Count(Product_types_f))

Re: Dimension and Expression Pivot table issue

Chanty4u — Wed, 03 May 2023 16:38:56 GMT

Can you try this

To get the total count for MTD Achieved, you can use the Sum aggregation function instead of the Count function in your expression. Also, you can remove the Pick function and directly use the Product_types_f field in your expression. The modified expression will be as follows:

=Sum(Product_types_f)

To calculate the FTM trend, you can use the following expression:

=Sum(Product_types_f)/($(=Max(Date))-$(=Min(Date)))