Tamamlanmış

Matrix Compare Report

Ok, let me explain..

In the sheet last tab (Local stockfile) has all the items (SKUs) they sell and cost and Retail prices.

Column A and B shows their departments and fine lines respectively.

3 rd tab (Trade01-06 Matrix extract) tab is the download of pricing discount structure. If you filter

column A you can see 6 types of Matrix IDs.

For example of if you just filter by column A by TRADE01.

 First from row 4 to 21 shows department discount structure

 From row 22 to row 50 shows Fineline discount structure

 Row 2 and 3 applies for all the items (skus).

2 nd tab (SKU check) is the ideal report im after. Basically when you enter Item (SKU) numer in cell A3

it shows all the discount structures, Column C to column P returns corresponding data from tab 2

(TRADE 01-06 Matrix extract). Sorry order in my sketch report tab (SKU Check) is not the same,,but

im basically after the same information.

Ignore columns from Q to Y in SKU check tab. This is to determine calculate best price depend on the

price basis, I can design this part.

If you can help me out to design what im after that would be great.

Let me know if you have any questiions.

---

cell I4 (best price) & J4 (GP%) is the best sell rate (column X) depending how many combination of matrices that item (SKu) has..Column Q to W you dont need to worry,

Beceriler: Veri Girişi, Veri İşleme, Excel, PHP, Yazılım Mimarisi

Daha fazlasını gör: ssrs matrix report column grouping, matrix report example, ssrs matrix report dynamic columns, difference between table and matrix in ssrs, ssrs list control example, a matrix or table can be attached to how many datasets?, by default - which item is not included in a matrix?, what is matrix report in ssrs, visit report auditor's office information, information broker knowledge broker cyberian freelance librarian researcher data dealer broker informacji infobroker infobrokera, information tablet check sheets data, display matrix ssrs report, compare report excel based primary key, report builder spool data, crystal report jsp export data

İşveren Hakkında:
( 0 değerlendirme ) New Zealand

Proje NO: #16947420

Seçilen:

prasannjeetp

Hi, I have seen your proposal. I am an excel expert with very good knowledge of formula and VBA. I can make this Matrix Compare Report for you. Please come on chat for more details. Awaiting your response. Thank you Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(14 Değerlendirme)
3.5

Bu iş için 12 freelancer ortalamada $25 teklif veriyor

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)
3.2
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
maiarif98

I am a highly trained in Data Entry, Research, Web search, Web scrape, great knowledge of Excel and all Social Networks. My bid is optional and I will let you chose the price that suits you best!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
Happydude1

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
arainjamil

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
Satish12345k

I wii do Relevant Skills and Experience I will do

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
ninhnt

Dear Mrs/Mss, I'm working with BI-matrix report everyday and good at VBA , i would like to chat over to know detail what you expect the result, i can give the expected result as well as you want. Thank you!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
adrmend

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde23%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0