Please use this starter dashboard to explain your answer if you can help! Comparative Sales I’m looking to create a side by side table view of a single customer sales vs another customer’s sales as well as the % difference between the two. I want these customers to be selected by the end user. I…

Hi @dspringer , Take a look at the Arena example that I put together, let me know if this is more similar to what you are trying to achieve: Comparitive Sales

Hi @dspringer you could create a workaround, if you only want to compare 2 customers. ComparativeSales BR

@ErikG thank you but this doesn’t meet the requirements as I’m looking for the dashboard user not the developer to define which customers are compared.

Hi @dspringer See if this is similar to your requirement. [image] Question about difference calculation in pivot table Question & Answer Hi, I have a Analysis as such: [Pasted Graphic 32 copy] With the same aggregation/dimensions showing in table, is there any way I …

Hi @dspringer , It’s been awhile since we last heard from you, did you have any additional questions regarding your case or were you able to find a work around? If we do not hear back within the next 3 business days, I’ll close out this topic. Thank you!

@Brett I was not able to find a work around and the suggested solutions didn’t meet the requirements.

Can you check if this works for you Forecast by Hour

@Brett this is effectively what I was looking to do but is there a way to toggle dimensions?

Hi @dspringer , What dimension(s) are you trying to toggle?

@Brett any would work but how about product? So effectively customer 1 and 2 would become product 1 and two but there needs to be a way to switch back and forth easily.

Hi @dspringer , You could try building another parameter that chooses ‘customer’ or ‘product’. Then setup the customer and product controls (dropdowns) to only show based on the new parameter’s selection (this would need to be completed in free-form). You won’t be able to handle the controls to hol…

Comparative Sales

Q&A

Giridhar.Prabhu November 26, 2024, 3:20pm 4

Hi @dspringer

See if this is similar to your requirement.

Topic		Replies	Views
How to choose two/many values from filter and compute the differece based on filtered view Q&A quick-sight , calculations , Business-Intelligence-Engineer	3	51	October 24, 2024
DIFFERENCE Q&A quick-sight , calculations , Business-Intelligence-Engineer	6	102	December 12, 2024
Question about difference calculation in pivot table Q&A spice , quick-sight , calculations	2	573	November 3, 2021
Difference between Two Rows Q&A quick-sight , visuals , Business-Intelligence-Engineer	4	215	June 11, 2024
Creating period comparisons with Quick Sight's periodOver and periodTo functions Technical Articles error , calculations	32	25418	November 21, 2024

Comparative Sales

Related topics