Need Help for a solution

[agni_gold]

Hi i am creating a straight table , also attaching the data , and required result in excel and sample application ,

Please help on this , I am explaining my required column.

Max Purchase Date for Customer        ---- Last purchase date for customer on which purchase happen (Amount not = 0)

Purchase happen on Maximum Date    ---- Purchase Amount on Maximum Date which is coming from above (Max Purchase Date for Customer )

Total Count of Days on which purchase happen in previous month from sysdate  ----  Number of days on which purchase happen (Amount not=0)  before previous month from Today's Month.(If Current Month is March then how many days in which purchase happen in Feb Month)

Total Count of Days on which purchase happen in previous month from Max Purchase date  ----Number of days on which purchase happen (Amount not=0)  before previous month from Max Purchase date month (If Max Date in Feb Month then need to count in Jan Month , and if Max Date in March month then need to count in Feb Month.)

And two more column for sum of Purchase amount as like above two columns.

Attaching my sample file also.

[agni_gold]

Hi all experts ,

I have created my required information from back end script , but i want to do all these work in front end expressions . Thats why i asked this question.

[swuehl · Accepted solution]

That's quite a lot of requests at once.

In general, I would try to avoid calculating measures in dimensions, that's what expressions are made for.

Have a look at the attached sample on how to calculate your measures using aggregation functions like Max() or FirstSortedValue and how to use advanced aggregation if you need to do more complex calculations.

[agni_gold]

Really thanks