Can someone help me allocate shared costs in QuickSight?

Question & Answer
, ,
1

QuickSight Q 1

Hi Quicksight experts, this is probably not possible due to aggregation issue but has anyone ever tried allocating shared costs?
The (overly simplistic) high level logic would be something like:

If Company = “Compu Electric” , then call this a Shared Cost and spread this to each other company weighted by their % Total to a new calculated field called Indirect Costs.

How would we go about doing something like this? Any help or guidance would be appreciated :slightly_smiling_face:

2

Hi @Zak_Brown

Welcome to QuickSight Community . I have sample dashboard for similar usecase to distribute the foundation project cost to rest of the project by month wise . Please have a look into this sample dashboard in Arena and you can refer to the calculated field expressions in it .

Distributed Monthly Foundation Project cost

image
image1157×552 30.7 KB

Thanks
Vinod

3

Hi @Zak_Brown,
It’s been awhile since we last heard from you. Did you have any additional questions regarding your initial topic or did Vinod’s response help with what you were looking to achieve?

If we do not hear back within the next 3 business days, I’ll go ahead and mark the solution.

Thank you!

4

Hi @Zak_Brown,
Since we have not heard back, I’ll go ahead and mark this as solved. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!