Summarize & Output Different Results

[sslattery17]

Request: Need help with approach or design, see screen shots of workflow and sheet names = (Properties).

Each of these properties include similar column data but several have a different calculation.  Example: property 1 could be Rent = Rent + Storage, property 2 Rent = Rent + Storage + Parking, Property 3 Rent = Rent + Amenity Rent + Storage or Property 4 Rent = Rent

Workflow is built to bring in all the properties, generate all the columns currently; now just trying to figure out best approach to get each property output with the appropriate calculations without building a separate workflow.  Any suggestions welcome. 

 

 

[CoG]

Do you have a data source that indicates what values contribute to total Rent? I'm thinking of a table with the following information:

Property	Field
Prop #1	Rent
Prop #1	Storage
Prop #2	Rent
Prop #2	Storage
Prop #2	Parking

Transpose the main data on all relevant rent fields, and join to the above dataset. Summarize Tool will calculate total Rent.

Please provide more specific info (including sample data) for more specific assistance.

Hope this helps and Happy Solving!

[nagakavyasri]

@sslattery17 As per my understanding, I think you are looking to write output to multiple sheets. Consider the field which has the differentiating column and try this:

[sslattery17]

@CoG 

I have attached a zip file with dataset workflow etc...I currently do not have a table (key) that shows what each properties customization is; but could easily create one since the client sends us this data. (I attached a sample of what I was starting to create). 

[sslattery17]

@nagakavyasri  yes partially what I am looking for.  I already have my output file configured to output by property; but I also need to have a different calculations/summarization by property.