Hi Please help - Need to

[vinaya mahantesh]

I have a file with products and their prices against bought from different vendors at different month and dates. I want to prepare a chart or a report in a format where i will be able to see a product and its price variation against vendors for different dates & month highlighting the Max price and the minimum price for that product.

ex :

Product Month Date Vendor Price
BOOK Sep 1 Birla 100
Clip Oct 2 Mediam 101
Pen Nov 5 Forbes 102
ink Dec 6 Deskron 103
Water Jan 9 Foorm 104
book Feb 10 Birla 105
BOOK Mar 13 Mediam 106
Clip Apr 15 Forbes 107
Pen May 17 Deskron 108
ink Jun 19 Foorm 109
Water Jul 21 Birla 110
book Aug 23 Mediam 111
BOOK Sep 25 Forbes 112

 

[Faseeh]

Hi vinaya,

Does this helps??

 

[vinaya mahantesh]

Hi vinaya,

Does this helps??

Hi Faseeh,


Thanks for a quick revert. But i want to see it against a particular date n month how the prices are varying . And I have about 17,000 products list. i just shared a sample. I also tried creating a dynamic dashboard, but have been asked for a requirement where that data could be scrolled .

 

[SirJB7]

Hi, vinaya mahantesh!

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

There you'll find this:
http://chandoo.org/forum/threads/new-users-please-read.294/
where you'll find this:
How to get the Best Results at Chandoo.org

• Use Relevant words in the Title and in the tag Box, This will aid future searches.

Please Don't

• Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out.

Regards!