Announcements
Hello All,
I want to export company net sales value from navision using excel buffer.below is the sample format .can anyone suggest how to acchive this using excel buffer
Primary Sales | ||||||||
Sales : Month | CY | LYSM | Absolute change | % change | Target | Achievement | ||
Apr | 12 | 456456 | 0.01 | |||||
May | 113 | 321 | 0.22 | |||||
Jun | 456 | 45 | 0.335 | |||||
Jul | 46 | 46 | 0.125 | |||||
Aug | ||||||||
Sep | ||||||||
MAT Figure | Sep 21 - Oct 22 | Sep20 to Oct20 | Absolute change | % change | ||||
46546 | 11 | |||||||
456 | 87 | |||||||
545 | ||||||||
Sales YTD breakup by segments | YTD | LY YTD | Absolute change | % change | Share of growth | Salience YTD | Salience LY YTD | Change |
Corporate | 54 | 46 | 5465 | 0.31 | ||||
Distributors | 6544 | 5456 | 7 | 0.22 | 4 | |||
Mumbai | 45 | 87 | 221 | 4 | ||||
Hi, This should be possible if the number of rows is fixed.
Hope the following helps.
Thanks.
ZHU
Below is the format
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156