This was a bit tricky to do, but I found the answer in this video from Leila Gharani – you need to create names that return the contents of the ranges G2# and H2# and then use the names in the chart definitions. ![]() Last of all I created a column chart bound to the values in G2 and H2. The formula in H2 uses the CubeValue function to return the aggregated sales amount for each set. Since there are two rows in the Buckets table, this formula returns two sets. ![]() Here’s what these two formulas return: The formula in G2 takes three arrays – the values from the three columns in the Buckets table – and then loops over the values in those columns and uses the CubeSet function to return a set of the Products whose sales are between the lower and upper bounds.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |