• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to create this view

A

aks_npti

New Member
Hi All,

I need your help with below. I have a excel spreadsheet which look like below :

Service Id's are repeated across the various company id's.

Requirement - To create a view :
  1. Total amount need to be splitted equally across the service id's ( for example if total amount is $1000 across 5 service id then each service id contribute to $200)
  2. Total Amount spent ( each company id & service id )
The data run over 10000+ rows.

Please let me know if the ask is not clear. Thanks in advance for the suggestions and help!

Company IdCompany NameTotal AmountService Id
1001A1$15000100069,100066,100513,100503,100507
1002A2$189000
100069,100066,100513
1003A3$23657100069,100066,100513,100503
1004A4$8975100069,100066
1005A5$67463100513,100503,100507
 
aks_npti
As You have an Excel file
... then You should upload here a sample Excel -file, which has Your sample data
... with clear rules
... with expected results - based Your given sample data as well as Your given clear rules.
 
Tot start with, ask your question the correct way the first time..
Second have a good look at the post of Vletm and comply.
Very simple, if you don't do any effort yourself ,why should we helpers spent our time finding a solution for your topic.
My suggestion is,no further help should be offered if you don't comply Vletm request.
 
vletm said:
aks_npti
As You have an Excel file
... then You should upload here a sample Excel -file, which has Your sample data
... with clear rules
... with expected results - based Your given sample data as well as Your given clear rules.
Click to expand...
Sorry was using mobile hence used the table. Uploading the excel now. Thanks
 
Hi All,

I need your help with below. I have a excel spreadsheet which look like below (attached ) :

Service Id's are repeated across the various company id's.

Requirement - To create a view :
  1. Total amount need to be splitted equally across the service id's ( for example if total amount is $1000 across 5 service id then each service id contribute to $200)
  2. Total Amount spent ( each company id & service id )
The data run over 10000+ rows.

Please let me know if the ask is not clear. Thanks in advance for the suggestions and help!
 

Attachments

  • Report Data.xlsx
    7.1 KB · Views: 10
aks_npti
Do You need those four rows before Required View as with Your sample file?
or
Do You have an idea that Required View would start always eg from row 20000?
or
Do You need only 40% of rows of data?

If 10000+ rows data,
do You expect formula solution?
or
what would be possible to use there?

You ( aks_npti ) should have a clear rules,
what and how would You like to see?
 
vletm said:
aks_npti
Do You need those four rows before Required View as with Your sample file?
or
Do You have an idea that Required View would start always eg from row 20000?
or
Do You need only 40% of rows of data?

If 10000+ rows data,
do You expect formula solution?
or
what would be possible to use there?

You ( aks_npti ) should have a clear rules,
what and how would You like to see?
Click to expand...

The requirement is to have the final view as depicted in the Required View. Sample data is not required in the final view.

If possible with excel formula , it will be great.
 
aks_npti
My #1 Do ... maybe needs?
My #2 Do ... okay, Required View starts from row 13 ... hmm?
My #3 Do ... okay - data from rows 3 & 4 are needed.
... with formulas
... okay, I tried, but maybe someone else would do it ... for 10000+ rows ... but only two would use ... hmm?
 
aks_npti
You should reread Forum Rules:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
There are clear steps - what should You follow if You're using cross-posting.
Those rules are for You too.
 
You must log in or register to reply here.
Back
Top