Dear Sir
i have 500k rows csv data which is having from 2020(Previous Year) also i maded two measure "Current Year CBM", and "Last Year CBM" now i need to calculate % from Grand Total of each month , after some time each product /sale man also will come , please advie how
i have 500k rows csv data which is having from 2020(Previous Year) also i maded two measure "Current Year CBM", and "Last Year CBM" now i need to calculate % from Grand Total of each month , after some time each product /sale man also will come , please advie how
=CALCULATE(sum([cbm]),k5ShipmentData[Custom]="Last Year") | |||||
MonthNum | Month | Current Year CBM | % | Last Year CBM | % |
1 | January | 3,422.00 | 20% | 3,372.00 | 8% |
2 | February | 2,568.00 | 15% | 4,243.00 | 10% |
3 | March | 2,946.00 | 17% | 5,891.00 | 14% |
4 | April | 1,284.00 | 8% | 1,042.00 | 2% |
5 | May | 2,454.00 | 15% | 19,360.00 | 45% |
6 | June | 2,216.00 | 13% | 3,728.00 | 9% |
7 | July | 1,594.00 | 9% | 3,327.00 | 8% |
8 | August | 356.00 | 2% | 2,191.00 | 5% |
Grand Total | 16,840.00 | 100% | 43,154.00 | 100% |