Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone ,
I have a requirement were I need to calculate the dimensions value.
Eg. I have deposit as dimensions and there value is
1 month
2 month
3 month
4 month
Current month
I need to add up 1 month to 4 month as one value and add that value with current month value.
Is there any solution for this.
Post your sample dataset and desired results.
Broker 1 month 2 month 3 month 4 month 5 month currentmonth
aa 54456 34555 45566 34566 3456 674833
rr 54456 34555 45566 34566 3456 674833
now i need to sum up the values from 1month to 5month as overdue and then add up with current month value
Note: this 1month 2 month 3 month all come from a single dimension value as deposit.
i dont have access to give u the correct data set.
HI @Rocky6
Would this just be:
sum([1 month]) + sum([2 month]) + sum([3 month]) + sum([4 month]) + sum([5 month]) + sum(currentmonth)
Better however would be to use the CROSSTABLE function, to put each value on a separate row with a month column, something like:
CROSSTABLE (Period, Value, 1)
LOAD
*
FROM [... your data source ...];
You will find more information on CROSSTABLE in the help.
Steve
@Steve i need to declare in set analysis can you please help me out in this.
=Sum({<[Item ]={'1 Mth o/d'}>} [Final ]) + Sum({<[Item]={'2 Mths o/d'}>} [Final])
+ Sum({<[Item ]={'3 Mths o/d'}>} [Final]) + Sum({<[Item]={'4 Mths o/d'}>} [Final])
+ Sum({<[Item ]={'5 Mths o/d'}>} [Final]) + Sum({<[Item ]={'6 Mths o/d'}>} [Final ])
this is what i wrote in set analysis. is this the correct approach.
This will change for every month.
One more thing is i have to show difference values of each date.
Like today the value is 56
tomorrow is 50
the third column should be difference of both i(e) 6
how to bring this in table.
thanks in advance.
Rakesh
@Rocky6 I would suggest create some dummy data in excel and provide the output you required. That will help you getting answer quickly
This 1 mo | till 6month | we should | add as overdue | and keep as | one value | Due amont | Overdue+Due amount | ||
Broker | 1 month | 2 month | 3 month | 4month | 5month | 6month | Current month | Grand total | |
aa | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 210+70=280 | |
this should not be dynamic as user need to add more months in the overdue section.
one more thing is grand total of every month starting and that value we need to minus with daily data
Broker | GRand Total | 20/04/23 | Difference | 21/04/23 | Difference | 22/04/23 | Difference | ||
aa | 1500 | 1000 | 500 | 500 | 1000 | 1000 | 500 | ||