I’m working with AWS cost export data and want to allocate SavingPlanRecurringFee to AWS account groups in a proportion each account group is having SavingsPlanCoveredUsage. The specific issues I’m having: ‘SavingsPlanRecurringFee’ appears in dataset only in one row for each billing period. How t…

[image] ville.karkkainen: alysis I need to be able to filter based on account_name Hi @ville.karkkainen , the issue is, that QS filters the account_name and then runs the sumOver function. When using PRE_FILTER option in your calculation you can calc the sumOver function before filtering is …

Hi @ville.karkkainen , welcome to the community :tada: You can find a short introduction including screenshots here: [image] Add Distinct count of rows to a pivot Question & Answer Hi @Filo , regarding sharing your analysis. Before you click on share, the analysis need…

Hi @ville.karkkainen I tried to build a solution for your request in Arena. Conditional Table I created three fields: Only filter for SavingsPlanCoveredUsage : Cost for SavingsPlanCoveredUsage ifelse( {line_item_line_item_type} = "SavingsPlanCoveredUsage", {line_item_blended_cost}, …

Thanks for your efforts, they we’re helpful and directed me to correct direction! However there’s still one step to go. ‘SavingsPlanRecurringFee’ appear only once in dataset for each ‘bill_billing_period_start_date’ value (i.e. once for each month). Do you have any advice how to then use that value…

I was able to get the desired results by adding the following three new fields: CALC_savings_plan_recurring_fee ifelse( {line_item_line_item_type} = "SavingsPlanRecurringFee", {line_item_blended_cost}, 0 ) CALC_savings_plan_recurring_fee_sum sumOver(sum({CALC_savings_plan_recurring…

Also to take billing period in to account to correctly count recurring fee I modified the recurring fee as follows: CALC_savings_plan_recurring_fee_sum sumOver( sum({CALC_savings_plan_recurring_fee}), [{bill_billing_period_start_date}], POST_AGG_FILTER )

Actually at least one thing still remains. In Analysis I need to be able to filter based on account_name (CALC_account_group). Now savings plan usage and percentage are calculated over the filtered rows. However, that’s wrong. Savings plan usages and percentages must always be calculated over entire…

Hi @ville.karkkainen , I’m just checking in on this question, as we have not heard back from you. Did the response from @Nico help? If so, please mark his reply as solution, if we do not hear back in the next 3 days, we will archive the question. Many Thanks, Andrew

Yes it helped and I’ve managed to create desired solution in Quick Sight. Very positive feeling about this community support and especially big thanks to @Nico for being very helpful and quick in response!

Conditional Table level sum and percentile

Q&A

Nico May 15, 2024, 6:18am 2

Hi @ville.karkkainen ,

welcome to the community

You can find a short introduction including screenshots here:

Best regards,
Nico

Topic		Replies	Views
How to display a calculated field only on one specific row in a table visual Q&A quick-sight , calculations , Business-Intelligence-Engineer	4	44	December 3, 2025
Create percentage of total in a filtered table Q&A quick-sight , calculations , Business-Intelligence-Engineer	2	139	May 7, 2024
Calculate percent of total by row Q&A quick-sight , calculations	5	3040	January 16, 2025
Pivot Table内の[Percent of Total (全体比)] 関数を使わずにPercent of Totalを集計したい日本語で質問 \| Q&A calculations , pivot-table , Business-Intelligence-Engineer , Japanese	4	86	September 17, 2025
How to display Rank / % of the group after filtering Q&A charts , quick-sight , calculations	6	3116	February 10, 2023

Conditional Table level sum and percentile

Related topics