Færdiggjort

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,

Evner: Dataindførsel, Databehandling, Excel, PHP, Software Arkitektur

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) New Zealand

Projekt ID: #16947420

Tildelt til:

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 Flere

$30 USD på 1 dag
(14 bedømmelser)
3.5

12 freelancere byder i gennemsnit $25 på dette job

$25 USD på 1 dag
(6 bedømmelser)
3.2
$25 USD på 1 dag
(0 bedømmelser)
0.0
$25 USD på 1 dag
(0 bedømmelser)
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!

$25 USD på 1 dag
(0 bedømmelser)
0.0
Happydude1

A proposal has not yet been provided

$25 USD på 1 dag
(0 bedømmelser)
0.0
$25 USD på 1 dag
(0 bedømmelser)
0.0
arainjamil

A proposal has not yet been provided

$25 USD på 1 dag
(0 bedømmelser)
0.0
Satish12345k

I wii do Relevant Skills and Experience I will do

$25 USD på 1 dag
(0 bedømmelser)
0.0
$25 USD på 1 dag
(0 bedømmelser)
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!

$25 USD på 1 dag
(0 bedømmelser)
0.0
adrmend

A proposal has not yet been provided

$23 USD in 2 dage
(0 bedømmelser)
0.0